VIEW: APPS.OKL_OR_SUBSIDY_REFUNDS

Source

View Text - Preformatted

SELECT cpl.id cpl_id, clets.dnz_chr_id, clets.id clets_id, subb.id subsidy_id, subb.name subsidy_name, pyd.id, pyd.object_version_number, pyd.cpl_id pyd_cpl_id, cpl.object1_id1, pov.vendor_id, pov.vendor_name vendor_name, pyd.pay_site_id, pvs.vendor_site_code pay_site_name, pyd.payment_term_id, apt.name payment_term_name, pyd.payment_method_code, aplk.displayed_field payment_method_name, pyd.pay_group_code, polk.displayed_field pay_group_name FROM okc_k_lines_b clets, okl_k_lines klets, okl_party_payment_dtls pyd, po_vendors pov, po_vendor_sites_all pvs, ap_terms_tl apt, ap_lookup_codes aplk, po_lookup_codes polk, okc_k_party_roles_b cpl, okl_subsidies_b subb WHERE clets.id = klets.id AND klets.subsidy_id = subb.id AND clets.id = cpl.cle_id AND pyd.cpl_id(+) = cpl.id AND pov.vendor_id(+) = cpl.object1_id1 AND pvs.vendor_site_id(+) = pyd.pay_site_id AND apt.term_id(+) = pyd.payment_term_id AND apt.language(+) = USERENV('LANG') AND aplk.lookup_type(+) = 'PAYMENT METHOD' AND aplk.lookup_code(+) = pyd.payment_method_code AND polk.lookup_type(+) = 'PAY GROUP' AND polk.lookup_code(+) = pyd.pay_group_code

View Text - HTML Formatted

SELECT CPL.ID CPL_ID
, CLETS.DNZ_CHR_ID
, CLETS.ID CLETS_ID
, SUBB.ID SUBSIDY_ID
, SUBB.NAME SUBSIDY_NAME
, PYD.ID
, PYD.OBJECT_VERSION_NUMBER
, PYD.CPL_ID PYD_CPL_ID
, CPL.OBJECT1_ID1
, POV.VENDOR_ID
, POV.VENDOR_NAME VENDOR_NAME
, PYD.PAY_SITE_ID
, PVS.VENDOR_SITE_CODE PAY_SITE_NAME
, PYD.PAYMENT_TERM_ID
, APT.NAME PAYMENT_TERM_NAME
, PYD.PAYMENT_METHOD_CODE
, APLK.DISPLAYED_FIELD PAYMENT_METHOD_NAME
, PYD.PAY_GROUP_CODE
, POLK.DISPLAYED_FIELD PAY_GROUP_NAME
FROM OKC_K_LINES_B CLETS
, OKL_K_LINES KLETS
, OKL_PARTY_PAYMENT_DTLS PYD
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, AP_TERMS_TL APT
, AP_LOOKUP_CODES APLK
, PO_LOOKUP_CODES POLK
, OKC_K_PARTY_ROLES_B CPL
, OKL_SUBSIDIES_B SUBB
WHERE CLETS.ID = KLETS.ID
AND KLETS.SUBSIDY_ID = SUBB.ID
AND CLETS.ID = CPL.CLE_ID
AND PYD.CPL_ID(+) = CPL.ID
AND POV.VENDOR_ID(+) = CPL.OBJECT1_ID1
AND PVS.VENDOR_SITE_ID(+) = PYD.PAY_SITE_ID
AND APT.TERM_ID(+) = PYD.PAYMENT_TERM_ID
AND APT.LANGUAGE(+) = USERENV('LANG')
AND APLK.LOOKUP_TYPE(+) = 'PAYMENT METHOD'
AND APLK.LOOKUP_CODE(+) = PYD.PAYMENT_METHOD_CODE
AND POLK.LOOKUP_TYPE(+) = 'PAY GROUP'
AND POLK.LOOKUP_CODE(+) = PYD.PAY_GROUP_CODE