Product: | OKL - Lease and Finance Management |
---|---|
Description: | User Interface view for passthrough base term related pages |
Implementation/DBA Data: | APPS.OKL_PSTHRU_BASE_PMNT_DTL_UV |
SELECT VEND.NAME PARTY_NAME
, VEND.ID1 OBJECT1_ID1
, VEND.ID2 OBJECT1_ID2
, B_DTL.CPL_ID CPL_ID
, NULL E_PASSTHRU_TERM
, NULL E_PAYMENT_DTLS_ID
, NULL E_PAYMENT_HDR_ID
, NULL E_PAY_SITE_ID
, NULL E_PAY_GROUP_CODE
, NULL E_PAYMENT_TERM_ID
, NULL E_PAYMENT_METHOD_CODE
, NULL E_PAYMENT_BASIS
, NULL E_PAYMENT_START_DATE
, NULL E_PAYMENT_FREQUENCY
, NULL E_REMIT_DAYS
, NULL E_DISBURSEMENT_BASIS
, NULL E_DISBURSEMENT_FIXED_AMOUNT
, NULL E_DISBURSEMENT_PERCENT
, NULL E_PROCESSING_FEE_BASIS
, NULL E_PROCESSING_FEE_FIXED_AMOUNT
, NULL E_PROCESSING_FEE_PERCENT
, B_HDR.CLE_ID CLE_ID
, B_HDR.PASSTHRU_TERM B_PASSTHRU_TERM
, B_HDR.PAYOUT_BASIS B_PAYOUT_BASIS
, B_DTL.ID B_PAYMENT_DTLS_ID
, B_DTL.PAYMENT_HDR_ID B_PAYMENT_HDR_ID
, B_DTL.PAY_SITE_ID B_PAY_SITE_ID
, B_DTL.PAY_GROUP_CODE B_PAY_GROUP_CODE
, B_DTL.PAYMENT_TERM_ID B_PAYMENT_TERM_ID
, B_DTL.PAYMENT_METHOD_CODE B_PAYMENT_METHOD_CODE
, B_DTL.PAYMENT_BASIS B_PAYMENT_BASIS
, B_DTL.PAYMENT_START_DATE B_PAYMENT_START_DATE
, B_DTL.PAYMENT_FREQUENCY B_PAYMENT_FREQUENCY
, B_DTL.REMIT_DAYS B_REMIT_DAYS
, B_DTL.DISBURSEMENT_BASIS B_DISBURSEMENT_BASIS
, B_DTL.DISBURSEMENT_FIXED_AMOUNT B_DISBURSEMENT_FIXED_AMOUNT
, B_DTL.DISBURSEMENT_PERCENT B_DISBURSEMENT_PERCENT
, B_DTL.PROCESSING_FEE_BASIS B_PROCESSING_FEE_BASIS
, B_DTL.PROCESSING_FEE_FIXED_AMOUNT B_PROCESSING_FEE_FIXED_AMOUNT
, B_DTL.PROCESSING_FEE_PERCENT B_PROCESSING_FEE_PERCENT
FROM OKX_VENDORS_V VEND
, OKL_PARTY_PAYMENT_DTLS B_DTL
, OKL_PARTY_PAYMENT_HDR B_HDR
WHERE B_HDR.ID = B_DTL.PAYMENT_HDR_ID (+)
AND B_HDR.PASSTHRU_TERM = 'BASE'
AND B_DTL.VENDOR_ID = VEND.ID1 (+)