Product: | OKL - Lease and Finance Management |
---|---|
Description: | User interface view that displays payment information for a context vendor |
Implementation/DBA Data: | APPS.OKL_LA_VENDOR_PAYMENTS_UV |
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