RMA

Hi ​@Ozge 

I don’t think there is a way to see this from application level.

You can view this form PLSQL Developer or IFS Developer Studio. Relevant tables are CUSTOMER_ORDER_TAB, CUSTOMER_ORDER_LINE_TAB and customer_order_pur_order_tab

Thanks & Regards,
Asanka.

Hi ​@Ozge ,

 

This can be displayed as a view on the db side. You can understand the data it feeds by examining the relevant view code.

SELECT co.order_no                              order_no,
       col.contract                             contract,
       co.customer_no                           customer_no,
       co.currency_code                         currency_code,
       col.catalog_no                           catalog_no,
       Sales_Part_API.Get_Catalog_Desc_For_Lang(col.contract, col.catalog_no, Fnd_Session_API.Get_Language()) catalog_desc,
       col.line_no                              line_no,
       col.rel_no                               rel_no,
       col.line_item_no                         line_item_no,
       co.customer_po_no                        customer_po_no,
      ((col.qty_shipped - col.qty_returned) / col.conv_factor * col.inverted_conv_factor) poss_qty_to_return,
       col.qty_invoiced                         qty_invoiced,
       col.qty_shipped                          qty_shipped,
       col.qty_returned                         qty_returned,
       cop.po_order_no                          po_order_no,
       cop.po_line_no                           po_line_no,         
       cop.po_rel_no                            po_rel_no,
       Order_Supply_Type_API.Decode(col.supply_code) supply_code,
       col.supply_code                          supply_code_db,
      -- col.CUSTOMER_ORDER_LINE_API.Finite_State_Decode__(rowstate)                               state,
       col.rowkey                              objkey
FROM   CUSTOMER_ORDER_TAB co, CUSTOMER_ORDER_LINE_TAB col, customer_order_pur_order_tab cop
WHERE  co.order_no = col.order_no
AND    col.rowstate IN ('Delivered', 'PartiallyDelivered', 'Invoiced')
AND    col.catalog_type !='PKG'
AND    col.part_ownership IN ('COMPANY OWNED', 'SUPPLIER RENTED', 'COMPANY RENTAL ASSET')
AND    col.order_no = cop.oe_order_no (+)
AND    col.line_no = cop.oe_line_no   (+)
AND    col.rel_no  = cop.oe_rel_no    (+)
AND    col.line_item_no = cop.oe_line_item_no (+)
AND    col.order_no IN (SELECT * FROM customer_order_usg)
AND    EXISTS (SELECT 1 FROM user_allowed_site_pub WHERE col.contract = site)
WITH   READ ONLY