Showing posts with label ITEM_IDENTIFIER_TYPE. Show all posts
Showing posts with label ITEM_IDENTIFIER_TYPE. Show all posts

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