[Home] [Help]
| Product: | BIC - Customer Intelligence (obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT A.SOLD_TO_ORG_ID CUSTOMER_ID
, A.ORG_ID
, A.ORDER_NUMBER
, A.ORDERED_DATE
, A.HEADER_ID
, A.SALESREP_ID
, A.TRANSACTIONAL_CURR_CODE
, TL.NAME ORDER_TYPE
, PA1.PERSON_FIRST_NAME||' '||PA1.PERSON_LAST_NAME BILL_TO_CONTACT
, BA.ADDRESS BILL_TO
, SA.ADDRESS SHIP_TO
, A.CREATION_DATE
, A.OPEN_FLAG
, A.CUST_PO_NUMBER PURCHASE_ORDER
, A.INVOICING_RULE_ID
, A.PAYMENT_TERM_ID
, A.PRICE_LIST_ID
, A.AGREEMENT_ID
FROM ASO_I_OE_ORDER_HEADERS_V A
, HZ_PARTIES PA1
, BIC_ADDRESS_V BA
, HZ_CUST_SITE_USES_ALL BB
, HZ_CUST_ACCT_SITES_ALL BC
, HZ_PARTY_SITES BD
, BIC_ADDRESS_V SA
, HZ_CUST_SITE_USES_ALL SB
, HZ_CUST_ACCT_SITES_ALL SC
, HZ_PARTY_SITES SD
, OE_TRANSACTION_TYPES_TL TL
WHERE A.ORDER_TYPE_ID=TL.TRANSACTION_TYPE_ID(+)
AND A.INVOICE_TO_CONTACT_ID=PA1.PARTY_ID(+)
AND A.INVOICE_TO_ORG_ID=BB.SITE_USE_ID(+)
AND BB.CUST_ACCT_SITE_ID=BC.CUST_ACCT_SITE_ID
AND BC.PARTY_SITE_ID=BD.PARTY_SITE_ID
AND BD.LOCATION_ID=BA.LOCATION_ID
AND A.SHIP_TO_ORG_ID=SB.SITE_USE_ID(+)
AND SB.CUST_ACCT_SITE_ID=SC.CUST_ACCT_SITE_ID
AND SC.PARTY_SITE_ID=SD.PARTY_SITE_ID
AND SD.LOCATION_ID=SA.LOCATION_ID WITH READ ONLY