Product: | IBE - iStore |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBE_ORDER_SUM_V |
SELECT OH.HEADER_ID
, OH.CREATED_BY
, OH.SOURCE_DOCUMENT_ID
, OH.ORIG_SYS_DOCUMENT_REF
, OH.ORDER_NUMBER
, OH.ORDERED_DATE
, OH.FLOW_STATUS_CODE ORDER_STATUS
, OH.SOLD_TO_ORG_ID CUST_ACCOUNT_ID
, CUST.PARTY_ID
, CUST.PARTY_NAME CUSTOMER_NAME
, OH.CUST_PO_NUMBER
, SUBSTR(OH.CREDIT_CARD_NUMBER
, (LENGTH(OH.CREDIT_CARD_NUMBER)-3)
, 4)
, OH.ORDER_CATEGORY_CODE
, OH.BOOKED_DATE
, OH.SOLD_TO_CONTACT_ID
, OH.CANCELLED_FLAG
, OH.OPEN_FLAG
, OH.BOOKED_FLAG
, OH.SOURCE_DOCUMENT_ID
, OH.SOURCE_DOCUMENT_TYPE_ID
, OEL.MEANING
, HCS.CUST_ACCOUNT_ID
, HCSU.CUST_ACCT_SITE_ID
, OH.ORG_ID ORG_ID
FROM OE_ORDER_HEADERS_ALL OH
, HZ_CUST_ACCOUNTS ACCT
, HZ_PARTIES CUST
, OE_LOOKUPS OEL
, HZ_CUST_SITE_USES_ALL HCSU
, HZ_CUST_ACCT_SITES_ALL HCS
WHERE OH.SOLD_TO_ORG_ID = ACCT.CUST_ACCOUNT_ID
AND ACCT.PARTY_ID = CUST.PARTY_ID
AND OEL.LOOKUP_CODE = OH.FLOW_STATUS_CODE
AND OEL.LOOKUP_TYPE = 'FLOW_STATUS'
AND OH.INVOICE_TO_ORG_ID = HCSU.SITE_USE_ID(+)
AND HCSU.CUST_ACCT_SITE_ID = HCS.CUST_ACCT_SITE_ID(+)