Product: | ASO - Order Capture |
---|---|
Description: | Order lines |
Implementation/DBA Data: | APPS.ASO_I_ORDER_LINES_V |
SELECT OL.LINE_ID
, OL.HEADER_ID
, OL.LINE_CATEGORY_CODE
, OL.LINE_NUMBER
, OL.ORDER_QUANTITY_UOM
, OL.ORDERED_QUANTITY
, OL.INVENTORY_ITEM_ID
, OL.SHIPMENT_NUMBER
, OL.UNIT_SELLING_PRICE
, OL.UNIT_LIST_PRICE
, OL.SHIPPABLE_FLAG
, OL.SCHEDULE_SHIP_DATE
, OL.SCHEDULE_ARRIVAL_DATE
, OL.ACTUAL_SHIPMENT_DATE
, OL.ACTUAL_ARRIVAL_DATE
, OL.SHIPPED_QUANTITY
, OL.SHIP_TO_CONTACT_ID
, OL.CUST_MODEL_SERIAL_NUMBER
, OL.MODEL_GROUP_NUMBER
, OL.TOP_MODEL_LINE_ID
, OL.LINK_TO_LINE_ID
, OL.CANCELLED_FLAG
, OL.OPEN_FLAG
, OL.BOOKED_FLAG
, OL.OPTION_NUMBER
, OL.SHIPPING_QUANTITY_UOM
, OL.CANCELLED_QUANTITY
, OL.PROMISE_DATE
, OL.REQUEST_DATE
, OL.SHIPPING_METHOD_CODE
, OL.SHIPMENT_PRIORITY_CODE
, OL.LINE_TYPE_ID
, OL.PRICING_QUANTITY
, OL.PRICING_QUANTITY_UOM
, OL.FULFILLED_QUANTITY
, OL.SHIPPING_QUANTITY
, OL.ORDER_SOURCE_ID
, OL.MARKETING_SOURCE_CODE_ID
, OL.INVOICE_TO_ORG_ID
, OL.SHIP_TO_ORG_ID
, OL.ATO_LINE_ID
, OL.CREATION_DATE
, OL.LAST_UPDATE_DATE
, IT.SEGMENT1 ITEM_NAME
, IT.DESCRIPTION ITEM_DESCRIPTION
, PL.PRICE_LIST_ID
, PL.NAME
, PL.CURRENCY_CODE
, OL.SHIP_FROM_ORG_ID
FROM OE_ORDER_LINES_ALL OL
, QP_PRICE_LISTS_V PL
, MTL_SYSTEM_ITEMS_VL IT
WHERE OL.INVENTORY_ITEM_ID = IT.INVENTORY_ITEM_ID
AND IT.ORGANIZATION_ID = OE_PROFILE.VALUE('OE_ORGANIZATION_ID'
, OL.ORG_ID)
AND OL.PRICE_LIST_ID = PL.PRICE_LIST_ID(+)
AND NVL(OL.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)