VIEW: APPS.OKL_PSTHRU_BASE_PMNT_DTL_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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