Customer items in Oracle Order management

1.    How to identify whether a user entered a customer item (in ordered_item column in oe_order_lines_all) or internal item in order lines screen:

SELECT ITEM_IDENTIFIER_TYPE

FROM OE_ORDER_LINES_ALL

WHERE HEADER_ID= 54328710

2.    This table contains the mapping between the customer and customer items:

SELECT * FROM MTL_CUSTOMER_ITEMS

3. This table contains the mapping between the customer items and internal organization items:

SELECT * FROM MTL_CUSTOMER_ITEM_XREFS

4.    Can we receive an RMA against an order (Order initially booked with internal items) with customer items?

By default, whether you book the RMA order with customer items or internal items, oracle will only show the internal items at the time of receipt.

If you import RMA receipts by inserting customer items instead of internal items into rcv_transactions_interface & rcv_headers_interface table, still oracle will automatically convert the customer items to internal items and will do the RMA receipt.

SELECT   hp.party_name customer,
           ci.customer_item_number,
           ci.customer_item_desc,
           msi.segment1 item,
           msi.description item_desc,
           ci.customer_category_code,
           ci.item_definition_level,
           ci.commodity_code_id,
           ci.address_id
    FROM   hz_parties hp,
           hz_cust_accounts hca,
           mtl_system_items msi,
           mtl_customer_items ci,
           mtl_customer_item_xrefs ix
   WHERE       ci.customer_item_id = ix.customer_item_id
           AND ix.inventory_item_id = msi.inventory_item_id
           AND ix.master_organization_id = msi.organization_id
           AND ci.customer_id = hca.cust_account_id
           AND hca.party_id = hp.party_id
ORDER BY   1, 2