VIEW: APPS.OKL_LESSEE_AS_VENDORS_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')