View: OKL_OR_SUBSIDY_REFUNDS

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_OR_SUBSIDY_REFUNDS

View Text

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

Columns