Product: | IBE - iStore |
---|---|
Description: | This view is used to get the Order Line Details. This view is based on aso_i_oe_order_headers_v and aso_i_oe_order_lines_v. |
Implementation/DBA Data: | Not implemented in this database |
SELECT OL.LINE_ID
, OL.HEADER_ID
, OL.LINE_CATEGORY_CODE
, OL.LINE_NUMBER
, OL.ORDER_QUANTITY_UOM
, OL.ORDERED_QUANTITY
, MSI.SEGMENT1 ITEM_NUMBER
, MSI.DESCRIPTION ITEM_DESCRIPTION
, OL.SHIPMENT_NUMBER
, TO_CHAR(OL.UNIT_SELLING_PRICE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(TRANSACTIONAL_CURR_CODE
, 30))
, TO_CHAR(OL.UNIT_LIST_PRICE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(TRANSACTIONAL_CURR_CODE
, 30))
, TO_CHAR(NVL(OL.UNIT_SELLING_PRICE
, 0)*( NVL(OL.ORDERED_QUANTITY
, 0) - NVL(OL.CANCELLED_QUANTITY
, 0) )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(OH.TRANSACTIONAL_CURR_CODE
, 30)) EXTENDED_PRICE
, 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.INVOICE_TO_ORG_ID
, OL.SHIP_TO_ORG_ID
, OL.ATO_LINE_ID
, OL.CREATION_DATE
, OL.LAST_UPDATE_DATE
, OH.TRANSACTIONAL_CURR_CODE
FROM ASO_I_OE_ORDER_LINES_V OL
, ASO_I_OE_ORDER_HEADERS_V OH
, MTL_SYSTEM_ITEMS_VL MSI
WHERE OL.HEADER_ID = OH.HEADER_ID
AND OL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = OE_PROFILE.VALUE('OE_ORGANIZATION_ID'
, OL.ORG_ID)