Product: | OKL - Leasing and Finance Management |
---|---|
Description: | User interface view for subsidies party payment details page |
Implementation/DBA Data: | APPS.OKL_PARTY_PAYMENT_DTLS_UV |
SELECT PPYD.ID ID
, PPYD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CPLB.DNZ_CHR_ID DNZ_CHR_ID
, CPLB.CHR_ID CHR_ID
, CPLB.CLE_ID CLE_ID
, PPYD.CPL_ID CPL_ID
, PPYD.VENDOR_ID VENDOR_ID
, PV.VENDOR_NAME VENDOR_NAME
, PV.SEGMENT1 VENDOR_NUMBER
, 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
, APLK.DISPLAYED_FIELD PAYMENT_METHOD_NAME
, APLK.DESCRIPTION PAYMENT_METHOD_DESCR
, PPYD.PAY_GROUP_CODE PAY_GROUP_CODE
, POLK.DISPLAYED_FIELD PAY_GROUP_NAME
, POLK.DESCRIPTION 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 CPLB
, AP_LOOKUP_CODES APLK
, PO_LOOKUP_CODES POLK
WHERE CPLB.ID = PPYD.CPL_ID
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')
AND APLK.LOOKUP_TYPE(+) = 'PAYMENT METHOD'
AND APLK.LOOKUP_CODE(+) = PPYD.PAYMENT_METHOD_CODE
AND POLK.LOOKUP_TYPE(+) = 'PAY GROUP'
AND POLK.LOOKUP_CODE(+) = PPYD.PAY_GROUP_CODE