[Home] [Help]
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
Name |
PAYMENT_SCHEDULE_ID |
TRX_NUMBER |
BILLING_NUMBER |
INVOICE_CURRENCY_CODE |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
CUSTOMER_TRX_ID |
CUSTOMER_ID |
CLASS |
PURCHASE_ORDER |
RELATED_CUST_ID |
ACCOUNT_DESCRIPTION |