VIEW: APPS.ECE_CDMO_TRX_NUMBER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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