View: IBE_AR_RECEIVABLE_APPL_V

View Text

SELECT APP.ROWID ROW_ID
, APP.CASH_RECEIPT_ID CASH_RECEIPT_ID
, DECODE(APP.APPLIED_PAYMENT_SCHEDULE_ID
, -1
, L_ACC.MEANING
, PS_INV.TRX_NUMBER) TRX_NUMBER
, DECODE(APP.APPLIED_PAYMENT_SCHEDULE_ID
, -1
, NULL
, L_CLASS.MEANING) TRX_CLASS_NAME
, TO_CHAR(APP.AMOUNT_APPLIED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( PS_INV.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_APPLIED
, TO_CHAR(TO_NUMBER(DECODE(APP.APPLIED_PAYMENT_SCHEDULE_ID
, -1
, NULL
, NVL(APP.EARNED_DISCOUNT_TAKEN
, 0) + NVL(APP.UNEARNED_DISCOUNT_TAKEN
, 0)))
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( PS_INV.INVOICE_CURRENCY_CODE
, 30)) DISCOUNT
, APP.APPLY_DATE APPLY_DATE
, TO_CHAR(PS_INV.AMOUNT_DUE_ORIGINAL
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( PS_INV.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_DUE_ORIGINAL
, TO_CHAR(TO_NUMBER(DECODE(APP.APPLIED_PAYMENT_SCHEDULE_ID
, -1
, APP.AMOUNT_APPLIED*-1
, PS_INV.AMOUNT_DUE_REMAINING))
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( PS_INV.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_DUE_REMAINING
, CUST.CUSTOMER_NAME CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER CUSTOMER_NUMBER
, SU.LOCATION LOCATION_NAME
, PS_INV.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PS_INV.CUSTOMER_ID CUSTOMER_ID
, PS_INV.STATUS STATUS
, PS_INV.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, CT.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CR.RECEIPT_NUMBER
FROM AR_PAYMENT_SCHEDULES PS_INV
, RA_CUSTOMER_TRX CT
, RA_SITE_USES SU
, AR_LOOKUPS L_CLASS
, AR_LOOKUPS L_ACC
, RA_CUSTOMERS CUST
, AR_RECEIVABLE_APPLICATIONS APP
, AR_CASH_RECEIPTS CR
WHERE APP.APPLIED_PAYMENT_SCHEDULE_ID = PS_INV.PAYMENT_SCHEDULE_ID
AND APP.DISPLAY = 'Y'
AND CT.CUSTOMER_TRX_ID(+) = PS_INV.CUSTOMER_TRX_ID
AND CUST.CUSTOMER_ID(+) = PS_INV.CUSTOMER_ID
AND SU.SITE_USE_ID(+) = CT.BILL_TO_SITE_USE_ID
AND PS_INV.CLASS = L_CLASS.LOOKUP_CODE
AND L_CLASS.LOOKUP_TYPE = 'INV/CM'
AND L_ACC.LOOKUP_TYPE = 'PAYMENT_TYPE'
AND L_ACC.LOOKUP_CODE= 'ACC'
AND CR.CASH_RECEIPT_ID = APP.CASH_RECEIPT_ID

Columns