View: IBE_ORDER_HEADER_ADV_V

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

View Text

SELECT OH.HEADER_ID
, OH.ORDER_NUMBER
, OH.CUST_PO_NUMBER
, OH.ORDERED_DATE
, OH.BOOKED_DATE
, OH.ORDER_CATEGORY_CODE
, OH.FLOW_STATUS_CODE
, OEL.MEANING ORDER_STATUS
, OH.SOURCE_DOCUMENT_ID
, OH.ORIG_SYS_DOCUMENT_REF
, OH.SOURCE_DOCUMENT_TYPE_ID
, OH.SOLD_TO_ORG_ID
, SOLD_TO_PARTY.PARTY_ID
, SOLD_TO_PARTY.PARTY_NAME CUSTOMER_NAME
, INV_ACCT_SITE.CUST_ACCOUNT_ID
, INV_SITE_USE.CUST_ACCT_SITE_ID
, SHP_ACCT_SITE.CUST_ACCOUNT_ID
, OH.END_CUSTOMER_ID
, OH.AGREEMENT_ID
, OH.CREATED_BY
, OH.ORG_ID ORG_ID
FROM OE_ORDER_HEADERS_ALL OH
, HZ_CUST_ACCOUNTS SOLD_TO_ACCOUNT
, HZ_PARTIES SOLD_TO_PARTY
, 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 OH.SOLD_TO_ORG_ID = SOLD_TO_ACCOUNT.CUST_ACCOUNT_ID
AND SOLD_TO_ACCOUNT.PARTY_ID = SOLD_TO_PARTY.PARTY_ID
AND OH.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 OH.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 = OH.FLOW_STATUS_CODE
AND OEL.LOOKUP_TYPE = 'FLOW_STATUS'

Columns