Product: | OKL - Lease and Finance Management |
---|---|
Description: | User interface view for vemdor (payment) details for a lessee(TCA party) |
Implementation/DBA Data: | APPS.OKL_LESSEE_AS_VENDORS_UV |
SELECT PPYD.ID ID
, PPYD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KPR.DNZ_CHR_ID
, PPYD.CPL_ID CPL_ID
, PPYD.VENDOR_ID VENDOR_ID
, PV.VENDOR_NAME
, PV.SEGMENT1
, PPYD.PAY_SITE_ID PAY_SITE_ID
, VS.VENDOR_SITE_CODE PAY_SITE_NAME
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, VS.ADDRESS_LINE1
, VS.ADDRESS_LINE2
, VS.ADDRESS_LINE3
, VS.ADDRESS_LINE4
, VS.CITY
, VS.COUNTY
, VS.STATE
, VS.PROVINCE
, VS.ZIP
, NULL
, VS.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) PAY_SITE_DESCR
, PPYD.PAYMENT_TERM_ID PAYMENT_TERM_ID
, APT.NAME PAYMENT_TERM_NAME
, APT.DESCRIPTION PAYMENT_TERM_DESCR
, PPYD.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, (SELECT APLK.DISPLAYED_FIELD
FROM AP_LOOKUP_CODES APLK
WHERE APLK.LOOKUP_TYPE = 'PAYMENT METHOD'
AND APLK.LOOKUP_CODE = PPYD.PAYMENT_METHOD_CODE) PAYMENT_METHOD_NAME
, NULL PAYMENT_METHOD_DESCR
, PPYD.PAY_GROUP_CODE PAY_GROUP_CODE
, (SELECT POLK.DISPLAYED_FIELD
FROM PO_LOOKUP_CODES POLK
WHERE POLK.LOOKUP_TYPE = 'PAY GROUP'
AND POLK.LOOKUP_CODE = PPYD.PAY_GROUP_CODE) PAY_GROUP_NAME
, NULL PAY_GROUP_DESCR
FROM OKL_PARTY_PAYMENT_DTLS PPYD
, PO_VENDORS PV
, PO_VENDOR_SITES VS
, AP_TERMS_TL APT
, OKC_K_PARTY_ROLES_B KPR
WHERE KPR.ID = PPYD.CPL_ID
AND KPR.RLE_CODE = 'LESSEE'
AND PV.VENDOR_ID = VS.VENDOR_ID
AND VS.VENDOR_SITE_ID(+) = PPYD.PAY_SITE_ID
AND APT.TERM_ID(+) = PPYD.PAYMENT_TERM_ID
AND APT.LANGUAGE(+) = USERENV('LANG')