VIEW: APPS.ASO_I_ORDER_LINES_V

Source

View Text - Preformatted

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 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(+)

View Text - HTML Formatted

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 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(+)