VIEW: APPS.OKL_LA_VENDOR_PAYMENTS_UV

Source

View Text - Preformatted

SELECT pph.id pph_id, pyd.id pyd_id, pyd.vendor_id, pph.passthru_term, lkp_psth_term.meaning passthru_term_name, 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_frequency, lkp_pay_freq.meaning payment_frequency_name, pyd.payment_basis, lkp_pay_basis.meaning payment_basis_name, pyd.cpl_id, pph.cle_id, pph.dnz_chr_id FROM okl_party_payment_hdr pph, okl_party_payment_dtls pyd, po_lookup_codes polk, ap_terms_tl apt, po_vendor_sites_all pvs, fnd_lookups lkp_pay_freq, fnd_lookups lkp_pay_basis, fnd_lookups lkp_psth_term WHERE pyd.payment_hdr_id = pph.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 pvs.vendor_id(+) = pyd.vendor_id AND pvs.vendor_site_id(+) = pyd.pay_site_id 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_psth_term.lookup_type (+) = 'OKL_PASSTHROUGH_TERM' AND lkp_psth_term.lookup_code (+) = pph.passthru_term

View Text - HTML Formatted

SELECT PPH.ID PPH_ID
, PYD.ID PYD_ID
, PYD.VENDOR_ID
, PPH.PASSTHRU_TERM
, LKP_PSTH_TERM.MEANING PASSTHRU_TERM_NAME
, 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_FREQUENCY
, LKP_PAY_FREQ.MEANING PAYMENT_FREQUENCY_NAME
, PYD.PAYMENT_BASIS
, LKP_PAY_BASIS.MEANING PAYMENT_BASIS_NAME
, PYD.CPL_ID
, PPH.CLE_ID
, PPH.DNZ_CHR_ID
FROM OKL_PARTY_PAYMENT_HDR PPH
, OKL_PARTY_PAYMENT_DTLS PYD
, PO_LOOKUP_CODES POLK
, AP_TERMS_TL APT
, PO_VENDOR_SITES_ALL PVS
, FND_LOOKUPS LKP_PAY_FREQ
, FND_LOOKUPS LKP_PAY_BASIS
, FND_LOOKUPS LKP_PSTH_TERM
WHERE PYD.PAYMENT_HDR_ID = PPH.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 PVS.VENDOR_ID(+) = PYD.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = PYD.PAY_SITE_ID
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_PSTH_TERM.LOOKUP_TYPE (+) = 'OKL_PASSTHROUGH_TERM'
AND LKP_PSTH_TERM.LOOKUP_CODE (+) = PPH.PASSTHRU_TERM