View: ECE_CDMO_TRX_NUMBER_V

Product:	EC - e-Commerce Gateway
Description:	Contains the credit/debit memo number for the customer for outbound Credit/Debit Memo (812 - CREADV / DEBADV) transaction.
Implementation/DBA Data:	APPS.ECE_CDMO_TRX_NUMBER_V

View Text

SELECT RCT1.TRX_NUMBER TRX_NUMBER
, RCT1.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, RCTT.TYPE DOCUMENT_TYPE
, CA.CUST_ACCOUNT_ID CUSTOMER_ID
, PT.PARTY_NAME CUSTOMER_NAME
FROM RA_CUSTOMER_TRX RCT1
, HZ_CUST_SITE_USES_ALL CSU
, HZ_CUST_ACCT_SITES_ALL CAS
, ECE_TP_HEADERS ETH
, ECE_TP_DETAILS ETD
, HZ_PARTIES PT
, HZ_CUST_ACCOUNTS CA
, RA_CUST_TRX_TYPES RCTT
WHERE RCT1.COMPLETE_FLAG = 'Y'
AND RCT1.PRINTING_PENDING = 'Y'
AND RCT1.PRINTING_OPTION = 'PRI'
AND ((ETD.DOCUMENT_ID = 'CDMO')
AND RCTT.TYPE IN ('DM'
, 'CM'))
AND RCT1.BILL_TO_CUSTOMER_ID = CA.CUST_ACCOUNT_ID
AND CA.PARTY_ID = PT.PARTY_ID
AND RCT1.BILL_TO_SITE_USE_ID = CSU.SITE_USE_ID
AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
AND RCT1.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
AND CAS.TP_HEADER_ID = ETH.TP_HEADER_ID
AND ETH.TP_HEADER_ID = ETD.TP_HEADER_ID
AND ETD.DOCUMENT_TYPE = RCTT.TYPE
AND ETD.EDI_FLAG = 'Y'
AND NVL(RCT1.EDI_PROCESSED_STATUS
, 'ED') IN ('ED'
, 'PR'
, 'EP')
AND NVL(RCT1.EDI_PROCESSED_FLAG
, 'N') = 'N'
AND ETD.DOCUMENT_TYPE = RCTT.TYPE

Columns