Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT OH.ORDER_NUMBER
, OH.VERSION_NUMBER
, NVL(OH.PAYMENT_AMOUNT
, 0)
, AST_QT_ORDER_TOTALS_PKG.ORDER_TOTAL(OH.HEADER_ID)
, OH.TRANSACTIONAL_CURR_CODE
, OH.ORDERED_DATE
, ACCT.PARTY_ID
, ACCT.CUST_ACCOUNT_ID
, OH.HEADER_ID
, OEL.MEANING
, ORG.CUSTOMER_NAME
, ORG.CUSTOMER_NUMBER
, CON.LAST_NAME || DECODE(CON.FIRST_NAME
, NULL
, NULL
, '
, '||CON.FIRST_NAME) || DECODE(CON.TITLE
, NULL
, NULL
, ' '||CON.TITLE)
, OT.NAME
, RAS.NAME
FROM OE_LOOKUPS OEL
, OE_TRANSACTION_TYPES_TL OT
, RA_SALESREPS RAS
, RA_CONTACTS CON
, RA_CUSTOMERS ORG
, HZ_CUST_ACCOUNTS ACCT
, OE_ORDER_HEADERS_ALL OH
WHERE OH.SOLD_TO_ORG_ID = ACCT.CUST_ACCOUNT_ID
AND OH.SOLD_TO_ORG_ID = ORG.CUSTOMER_ID (+)
AND OH.SOLD_TO_CONTACT_ID = CON.CONTACT_ID (+)
AND OH.SALESREP_ID = RAS.SALESREP_ID (+)
AND OH.FLOW_STATUS_CODE = OEL.LOOKUP_CODE (+)
AND OEL.LOOKUP_TYPE (+) = 'FLOW_STATUS'
AND OH.ORDER_TYPE_ID = OT.TRANSACTION_TYPE_ID
AND OT.LANGUAGE = USERENV('LANG')