View: IBE_ORDER_ITEMS_ADV_V

Product:	IBE - iStore
Description:
Implementation/DBA Data:	APPS.IBE_ORDER_ITEMS_ADV_V

View Text

SELECT OL.LINE_ID
, OL.HEADER_ID
, OH.ORDER_NUMBER
, OL.CUST_PO_NUMBER
, OH.ORDER_CATEGORY_CODE
, OL.LINE_CATEGORY_CODE
, OL.LINE_NUMBER
, OL.SHIPMENT_NUMBER
, OL.OPTION_NUMBER
, OL.COMPONENT_NUMBER
, OL.SERVICE_NUMBER
, MSI.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSI.DESCRIPTION ITEM_DESCRIPTION
, OL.ORDERED_QUANTITY
, OL.SHIPPED_QUANTITY
, OL.CANCELLED_QUANTITY
, OL.ORDER_QUANTITY_UOM
, MSIT.UNIT_OF_MEASURE_TL UOM_NAME
, MSI.SEGMENT6 LICENSING_UNIT
, OL.PRICING_ATTRIBUTE10
, OL.UNIT_SELLING_PRICE
, OL.UNIT_LIST_PRICE
, OH.TRANSACTIONAL_CURR_CODE
, OH.ORDERED_DATE
, OH.BOOKED_DATE
, OL.SCHEDULE_SHIP_DATE
, OL.REQUEST_DATE
, OL.PROMISE_DATE
, OL.ITEM_TYPE_CODE
, OL.TOP_MODEL_LINE_ID
, OL.LINK_TO_LINE_ID
, OL.ATO_LINE_ID
, OL.FLOW_STATUS_CODE
, OEL.MEANING LINE_STATUS
, OL.SERVICE_REFERENCE_TYPE_CODE
, OL.SERVICE_REFERENCE_LINE_ID
, OL.SERVICE_REFERENCE_SYSTEM_ID
, OL.SHIPPABLE_FLAG
, OL.AGREEMENT_ID
, OH.SOLD_TO_ORG_ID
, HDR_INV_ACCT_SITE.CUST_ACCOUNT_ID
, HDR_INV_SITE_USE.CUST_ACCT_SITE_ID
, INV_ACCT_SITE.CUST_ACCOUNT_ID
, SHP_ACCT_SITE.CUST_ACCOUNT_ID
, OL.END_CUSTOMER_ID
, OH.CREATED_BY
, OH.ORG_ID ORG_ID
FROM OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS_ALL OH
, MTL_SYSTEM_ITEMS_VL MSI
, MTL_UNITS_OF_MEASURE_TL MSIT
, HZ_CUST_SITE_USES_ALL HDR_INV_SITE_USE
, HZ_CUST_ACCT_SITES_ALL HDR_INV_ACCT_SITE
, HZ_CUST_SITE_USES_ALL INV_SITE_USE
, HZ_CUST_ACCT_SITES_ALL INV_ACCT_SITE
, HZ_CUST_SITE_USES_ALL SHP_SITE_USE
, HZ_CUST_ACCT_SITES_ALL SHP_ACCT_SITE
, OE_LOOKUPS OEL
WHERE OL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = OE_PROFILE.VALUE('OE_ORGANIZATION_ID'
, OL.ORG_ID)
AND OL.HEADER_ID = OH.HEADER_ID
AND OL.ORDER_QUANTITY_UOM = MSIT.UOM_CODE
AND MSIT.LANGUAGE = USERENV('LANG')
AND OH.INVOICE_TO_ORG_ID = HDR_INV_SITE_USE.SITE_USE_ID
AND HDR_INV_SITE_USE.CUST_ACCT_SITE_ID = HDR_INV_ACCT_SITE.CUST_ACCT_SITE_ID
AND OL.INVOICE_TO_ORG_ID = INV_SITE_USE.SITE_USE_ID(+)
AND INV_SITE_USE.CUST_ACCT_SITE_ID = INV_ACCT_SITE.CUST_ACCT_SITE_ID(+)
AND OL.SHIP_TO_ORG_ID = SHP_SITE_USE.SITE_USE_ID
AND SHP_SITE_USE.CUST_ACCT_SITE_ID = SHP_ACCT_SITE.CUST_ACCT_SITE_ID(+)
AND OEL.LOOKUP_CODE = OL.FLOW_STATUS_CODE
AND OEL.LOOKUP_TYPE = 'FLOW_STATUS'

Columns