VIEW: APPS.AR_ICR_TRX_V

Source

View Text - Preformatted

SELECT PS.PAYMENT_SCHEDULE_ID , PS.TRX_NUMBER , CI.CONS_BILLING_NUMBER BILLING_NUMBER , PS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE , SUBSTRB(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME , CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER , PS.CUSTOMER_TRX_ID , CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID , PS.CLASS , TRX.PURCHASE_ORDER , NULL RELATED_CUST_ID /*Bug 2304009 */ , CUST_ACCT.account_name FROM HZ_CUST_ACCOUNTS CUST_ACCT, HZ_PARTIES PARTY, HZ_CUSTOMER_PROFILES CP, RA_CUSTOMER_TRX TRX, AR_PAYMENT_SCHEDULES PS, AR_CONS_INV CI WHERE NVL(PS.STATUS,'OP') = 'OP' AND PS.CLASS NOT IN ( 'PMT', 'GUAR' ) AND PS.SELECTED_FOR_RECEIPT_BATCH_ID IS NULL AND PS.RESERVED_TYPE IS NULL /* 08-JUL-2000 J Rautiainen BR Implementation */ AND PS.RESERVED_VALUE IS NULL /* 08-JUL-2000 J Rautiainen BR Implementation */ AND PS.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID AND CUST_ACCT.CUST_ACCOUNT_ID = PS.CUSTOMER_ID AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID AND CUST_ACCT.CUST_ACCOUNT_ID = CP.CUST_ACCOUNT_ID AND CP.SITE_USE_ID IS NULL AND CI.CONS_INV_ID(+) = PS.CONS_INV_ID

View Text - HTML Formatted

SELECT PS.PAYMENT_SCHEDULE_ID
, PS.TRX_NUMBER
, CI.CONS_BILLING_NUMBER BILLING_NUMBER
, PS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
, PS.CUSTOMER_TRX_ID
, CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID
, PS.CLASS
, TRX.PURCHASE_ORDER
, NULL RELATED_CUST_ID /*BUG 2304009 */
, CUST_ACCT.ACCOUNT_NAME
FROM HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, HZ_CUSTOMER_PROFILES CP
, RA_CUSTOMER_TRX TRX
, AR_PAYMENT_SCHEDULES PS
, AR_CONS_INV CI
WHERE NVL(PS.STATUS
, 'OP') = 'OP'
AND PS.CLASS NOT IN ( 'PMT'
, 'GUAR' )
AND PS.SELECTED_FOR_RECEIPT_BATCH_ID IS NULL
AND PS.RESERVED_TYPE IS NULL /* 08-JUL-2000 J RAUTIAINEN BR IMPLEMENTATION */
AND PS.RESERVED_VALUE IS NULL /* 08-JUL-2000 J RAUTIAINEN BR IMPLEMENTATION */
AND PS.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = PS.CUSTOMER_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = CP.CUST_ACCOUNT_ID
AND CP.SITE_USE_ID IS NULL
AND CI.CONS_INV_ID(+) = PS.CONS_INV_ID