View: AR_ICR_TRX_V

Product:	AR - Receivables
Description:	(Release 115 Only)
Implementation/DBA Data:	APPS.AR_ICR_TRX_V

View Text

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

Columns