View: IBE_PAYMENT_DETAIL_V

Product:	IBE - iStore
Description:
Implementation/DBA Data:	APPS.IBE_PAYMENT_DETAIL_V

View Text

SELECT 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
, APP.AMOUNT_APPLIED
, TO_NUMBER(DECODE(APP.APPLIED_PAYMENT_SCHEDULE_ID
, -1
, NULL
, NVL(APP.EARNED_DISCOUNT_TAKEN
, 0) + NVL(APP.UNEARNED_DISCOUNT_TAKEN
, 0))) DISCOUNT
, APP.APPLY_DATE APPLY_DATE
, PS_INV.AMOUNT_DUE_ORIGINAL
, TO_NUMBER(DECODE(APP.APPLIED_PAYMENT_SCHEDULE_ID
, -1
, APP.AMOUNT_APPLIED*-1
, PS_INV.AMOUNT_DUE_REMAINING)) AMOUNT_DUE_REMAINING
, PS_INV.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PS_INV.STATUS STATUS
, AL_STATUS.MEANING STATUS_MEANING
, PS_INV.INVOICE_CURRENCY_CODE CURRENCY_CODE
, CR.RECEIPT_NUMBER
, PS_INV.ORG_ID ORG_ID
FROM AR_PAYMENT_SCHEDULES_ALL PS_INV
, AR_LOOKUPS L_CLASS
, AR_LOOKUPS L_ACC
, HZ_CUST_ACCOUNTS ACCT
, AR_RECEIVABLE_APPLICATIONS_ALL APP
, AR_CASH_RECEIPTS_ALL CR
, AR_LOOKUPS AL_STATUS
WHERE APP.APPLIED_PAYMENT_SCHEDULE_ID = PS_INV.PAYMENT_SCHEDULE_ID
AND APP.DISPLAY = 'Y'
AND PS_INV.CUSTOMER_ID = ACCT.CUST_ACCOUNT_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
AND PS_INV.STATUS = AL_STATUS.LOOKUP_CODE
AND AL_STATUS.LOOKUP_TYPE = 'INVOICE_TRX_STATUS'

Columns