Product: | OKL - Lease and Finance Management |
---|---|
Description: | User interface view to indicate passthrough vendors on a Passthrough Fee or Service |
Implementation/DBA Data: | APPS.OKL_LA_PASSTHRU_VENDOR_UV |
SELECT CPL.ID CPL_ID
, CPL.OBJECT1_ID1
, CPL.OBJECT1_ID2
, CPL.RLE_CODE
, CPL.CLE_ID
, CPL.DNZ_CHR_ID
, POV.VENDOR_NAME
, PYD.PAYMENT_HDR_ID
, PYD.ID PYD_ID
, PYD.VENDOR_ID
, 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_METHOD_CODE
, APLK.DISPLAYED_FIELD PAYMENT_METHOD_NAME
, PYD.PAYMENT_FREQUENCY
, LKP_PAY_FREQ.MEANING PAYMENT_FREQUENCY_NAME
, PYD.PAYMENT_BASIS
, LKP_PAY_BASIS.MEANING PAYMENT_BASIS_NAME
, PYD.PAYMENT_START_DATE
, PYD.REMIT_DAYS
, PYD.DISBURSEMENT_BASIS
, LKP_DISB_BASIS.MEANING DISBURSEMENT_BASIS_NAME
, PYD.DISBURSEMENT_FIXED_AMOUNT
, PYD.DISBURSEMENT_PERCENT
, PYD.PROCESSING_FEE_BASIS
, LKP_PROC_FEE_BASIS.MEANING PROCESSING_FEE_BASIS_NAME
, PYD.PROCESSING_FEE_FIXED_AMOUNT
, PYD.PROCESSING_FEE_PERCENT
FROM OKL_PARTY_PAYMENT_DTLS PYD
, OKC_K_PARTY_ROLES_B CPL
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, PO_LOOKUP_CODES POLK
, AP_TERMS_TL APT
, FND_LOOKUPS LKP_PAY_FREQ
, FND_LOOKUPS LKP_PAY_BASIS
, FND_LOOKUPS LKP_DISB_BASIS
, FND_LOOKUPS LKP_PROC_FEE_BASIS
, AP_LOOKUP_CODES APLK
WHERE CPL.RLE_CODE = 'OKL_VENDOR'
AND POV.VENDOR_ID = CPL.OBJECT1_ID1
AND PYD.CPL_ID (+) = CPL.ID
AND PVS.VENDOR_ID(+) = PYD.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = PYD.PAY_SITE_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 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_DISB_BASIS.LOOKUP_TYPE (+) = 'OKL_DISBURSE_BASIS'
AND LKP_DISB_BASIS.LOOKUP_CODE (+) = PYD.DISBURSEMENT_BASIS
AND LKP_PROC_FEE_BASIS.LOOKUP_TYPE (+) = 'OKL_PROC_FEE_BASIS'
AND LKP_PROC_FEE_BASIS.LOOKUP_CODE (+) = PYD.PROCESSING_FEE_BASIS
AND APLK.LOOKUP_TYPE (+) = 'PAYMENT METHOD'
AND APLK.LOOKUP_CODE (+) = PYD.PAYMENT_METHOD_CODE