VIEW: APPS.OKL_PSTHRU_EVRGRN_PMNT_DTL_UV

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)