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