Product: | BIC - Customer Intelligence (obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT OL.SOLD_TO_ORG_ID CUSTOMER_ID
, OL.ORG_ID
, OL.HEADER_ID
, OL.ORDERED_QUANTITY
, OL.SHIPPED_QUANTITY
, OL.CANCELLED_QUANTITY
, OL.ORDER_QUANTITY_UOM
, OL. UNIT_LIST_PRICE
, OL.UNIT_SELLING_PRICE
, OL.UNIT_SELLING_PRICE*ORDERED_QUANTITY EXTENDED_PRICE
, OL.PROMISE_DATE
, OL.SCHEDULE_SHIP_DATE
, OL.REQUEST_DATE
, MT.DESCRIPTION ITEM
FROM OE_ORDER_LINES_ALL OL
, MTL_SYSTEM_ITEMS MT
WHERE OL.INVENTORY_ITEM_ID=MT.INVENTORY_ITEM_ID(+)
AND FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID')=MT.ORGANIZATION_ID(+) WITH READ ONLY