VIEW: APPS.OKL_LA_PASSTHRU_VENDOR_UV

Source

View Text - Preformatted

SELECT cpl.id cpl_id, cpl.object1_id1, cpl.object1_id2, cpl.rle_code, cpl.cle_id, cpl.dnz_chr_id, pov.vendor_name, pyd.payment_hdr_id, pyd.id pyd_id, pyd.vendor_id, pyd.pay_site_id, pvs.vendor_site_code pay_site_name, pyd.pay_group_code, polk.displayed_field pay_group_name, pyd.payment_term_id, apt.name payment_term_name, pyd.payment_method_code, aplk.displayed_field payment_method_name, pyd.payment_frequency, lkp_pay_freq.meaning payment_frequency_name, pyd.payment_basis, lkp_pay_basis.meaning payment_basis_name, pyd.payment_start_date, pyd.remit_days, pyd.disbursement_basis, lkp_disb_basis.meaning disbursement_basis_name, pyd.disbursement_fixed_amount, pyd.disbursement_percent, pyd.processing_fee_basis, lkp_proc_fee_basis.meaning processing_fee_basis_name, pyd.processing_fee_fixed_amount, pyd.processing_fee_percent FROM okl_party_payment_dtls pyd, okc_k_party_roles_b cpl, po_vendors pov, po_vendor_sites_all pvs, po_lookup_codes polk, ap_terms_tl apt, fnd_lookups lkp_pay_freq, fnd_lookups lkp_pay_basis, fnd_lookups lkp_disb_basis, fnd_lookups lkp_proc_fee_basis, ap_lookup_codes aplk WHERE cpl.rle_code = 'OKL_VENDOR' AND pov.vendor_id = cpl.object1_id1 AND pyd.cpl_id (+) = cpl.id AND pvs.vendor_id(+) = pyd.vendor_id AND pvs.vendor_site_id(+) = pyd.pay_site_id AND polk.lookup_type (+) = 'PAY GROUP' AND polk.lookup_code (+) = pyd.pay_group_code AND apt.term_id(+) = pyd.payment_term_id AND apt.language(+) = USERENV('LANG') AND lkp_pay_freq.lookup_type (+) = 'OKL_PAYMENT_FRQ' AND lkp_pay_freq.lookup_code (+) = pyd.payment_frequency AND lkp_pay_basis.lookup_type (+) = 'OKL_PAYMENT_BASIS' AND lkp_pay_basis.lookup_code (+) = pyd.payment_basis AND lkp_disb_basis.lookup_type (+) = 'OKL_DISBURSE_BASIS' AND lkp_disb_basis.lookup_code (+) = pyd.disbursement_basis AND lkp_proc_fee_basis.lookup_type (+) = 'OKL_PROC_FEE_BASIS' AND lkp_proc_fee_basis.lookup_code (+) = pyd.processing_fee_basis AND aplk.lookup_type (+) = 'PAYMENT METHOD' AND aplk.lookup_code (+) = pyd.payment_method_code

View Text - HTML Formatted

SELECT CPL.ID CPL_ID
, CPL.OBJECT1_ID1
, CPL.OBJECT1_ID2
, CPL.RLE_CODE
, CPL.CLE_ID
, CPL.DNZ_CHR_ID
, POV.VENDOR_NAME
, PYD.PAYMENT_HDR_ID
, PYD.ID PYD_ID
, PYD.VENDOR_ID
, PYD.PAY_SITE_ID
, PVS.VENDOR_SITE_CODE PAY_SITE_NAME
, PYD.PAY_GROUP_CODE
, POLK.DISPLAYED_FIELD PAY_GROUP_NAME
, PYD.PAYMENT_TERM_ID
, APT.NAME PAYMENT_TERM_NAME
, PYD.PAYMENT_METHOD_CODE
, APLK.DISPLAYED_FIELD PAYMENT_METHOD_NAME
, PYD.PAYMENT_FREQUENCY
, LKP_PAY_FREQ.MEANING PAYMENT_FREQUENCY_NAME
, PYD.PAYMENT_BASIS
, LKP_PAY_BASIS.MEANING PAYMENT_BASIS_NAME
, PYD.PAYMENT_START_DATE
, PYD.REMIT_DAYS
, PYD.DISBURSEMENT_BASIS
, LKP_DISB_BASIS.MEANING DISBURSEMENT_BASIS_NAME
, PYD.DISBURSEMENT_FIXED_AMOUNT
, PYD.DISBURSEMENT_PERCENT
, PYD.PROCESSING_FEE_BASIS
, LKP_PROC_FEE_BASIS.MEANING PROCESSING_FEE_BASIS_NAME
, PYD.PROCESSING_FEE_FIXED_AMOUNT
, PYD.PROCESSING_FEE_PERCENT
FROM OKL_PARTY_PAYMENT_DTLS PYD
, OKC_K_PARTY_ROLES_B CPL
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, PO_LOOKUP_CODES POLK
, AP_TERMS_TL APT
, FND_LOOKUPS LKP_PAY_FREQ
, FND_LOOKUPS LKP_PAY_BASIS
, FND_LOOKUPS LKP_DISB_BASIS
, FND_LOOKUPS LKP_PROC_FEE_BASIS
, AP_LOOKUP_CODES APLK
WHERE CPL.RLE_CODE = 'OKL_VENDOR'
AND POV.VENDOR_ID = CPL.OBJECT1_ID1
AND PYD.CPL_ID (+) = CPL.ID
AND PVS.VENDOR_ID(+) = PYD.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = PYD.PAY_SITE_ID
AND POLK.LOOKUP_TYPE (+) = 'PAY GROUP'
AND POLK.LOOKUP_CODE (+) = PYD.PAY_GROUP_CODE
AND APT.TERM_ID(+) = PYD.PAYMENT_TERM_ID
AND APT.LANGUAGE(+) = USERENV('LANG')
AND LKP_PAY_FREQ.LOOKUP_TYPE (+) = 'OKL_PAYMENT_FRQ'
AND LKP_PAY_FREQ.LOOKUP_CODE (+) = PYD.PAYMENT_FREQUENCY
AND LKP_PAY_BASIS.LOOKUP_TYPE (+) = 'OKL_PAYMENT_BASIS'
AND LKP_PAY_BASIS.LOOKUP_CODE (+) = PYD.PAYMENT_BASIS
AND LKP_DISB_BASIS.LOOKUP_TYPE (+) = 'OKL_DISBURSE_BASIS'
AND LKP_DISB_BASIS.LOOKUP_CODE (+) = PYD.DISBURSEMENT_BASIS
AND LKP_PROC_FEE_BASIS.LOOKUP_TYPE (+) = 'OKL_PROC_FEE_BASIS'
AND LKP_PROC_FEE_BASIS.LOOKUP_CODE (+) = PYD.PROCESSING_FEE_BASIS
AND APLK.LOOKUP_TYPE (+) = 'PAYMENT METHOD'
AND APLK.LOOKUP_CODE (+) = PYD.PAYMENT_METHOD_CODE