View: OKL_FUND_REQ_HEADERS_UV

Product:	OKL - Leasing and Finance Management
Description:	User interface view for funding request header.
Implementation/DBA Data:	APPS.OKL_FUND_REQ_HEADERS_UV

View Text

SELECT H.ID FUND_ID
, H.VENDOR_INVOICE_NUMBER FUND_NUMBER
, H.CURRENCY_CODE
, LCT.NAME CURRENCY_NAME
, H.PAYMENT_METHOD_CODE
, LOOK1.MEANING PAYMENT_METHOD_NAME
, H.FUNDING_TYPE_CODE
, LOOK2.MEANING FUNDING_TYPE_NAME
, H.IPVS_ID VENDOR_SITE_ID
, H.KHR_ID CONTRACT_ID
, H.DATE_ENTERED
, H.DATE_INVOICED FUND_DUE_DATE
, H.DATE_FUNDING_APPROVED FUND_APPROVED_DATE
, OKL_FUNDING_PVT.GET_CONTRACT_LINE_FUNDED_AMT(H.ID
, H.FUNDING_TYPE_CODE) FUND_TOTAL
, H.TRX_STATUS_CODE
, LOOK3.MEANING TRX_STATUS_NAME
, H.TRY_ID FUND_TRX_TYPE_ID
, HL.DESCRIPTION FUND_DESCRIPTION
, V.VENDOR_ID
, V.SEGMENT1 VENDOR_NUMBER
, V.VENDOR_NAME
, VS.VENDOR_SITE_CODE
, VS.PAY_SITE_FLAG PAY_SITE_FLAG
, SUBSTR(DECODE(VS.ADDRESS_LINE1
, NULL
, NULL
, VS.ADDRESS_LINE1) || DECODE(VS.ADDRESS_LINE2
, NULL
, NULL
, ' '||VS.ADDRESS_LINE2) || DECODE(VS.ADDRESS_LINE3
, NULL
, NULL
, ' '||VS.ADDRESS_LINE3) || DECODE(VS.ADDRESS_LINE4
, NULL
, NULL
, ' '||VS.ADDRESS_LINE4) || DECODE(VS.CITY
, NULL
, NULL
, ' '||VS.CITY) || DECODE(VS.STATE
, NULL
, NULL
, ' '||VS.STATE) || DECODE(VS.PROVINCE
, NULL
, NULL
, ' '||VS.PROVINCE) || DECODE(VS.ZIP
, NULL
, NULL
, ' '||VS.ZIP) || DECODE(VS.COUNTRY
, NULL
, NULL
, '
, '||VS.COUNTRY)
, 1
, 80) VENDOR_SITE_ADDRESS
, H.ORG_ID ORG_ID
, NVL(H.INVOICE_TYPE
, DECODE(H.FUNDING_TYPE_CODE
, 'SUPPLIER_RETENTION'
, 'CREDIT'
, 'STANDARD'))
, LOOK4.MEANING
, H.PAY_GROUP_LOOKUP_CODE
, LOOK5.DISPLAYED_FIELD
, H.IPPT_ID
, TRM.NAME
FROM OKL_TRX_AP_INVOICES_B H
, OKL_TRX_AP_INVOICES_TL HL
, PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
, FND_CURRENCIES_TL LCT
, FND_LOOKUPS LOOK1
, FND_LOOKUPS LOOK2
, FND_LOOKUPS LOOK3
, FND_LOOKUPS LOOK4
, AP_TERMS_V TRM
, PO_LOOKUP_CODES LOOK5
WHERE H.ID = HL.ID
AND HL.LANGUAGE = USERENV('LANG')
AND H.IPVS_ID = VS.VENDOR_SITE_ID
AND VS.VENDOR_ID = V.VENDOR_ID
AND H.CURRENCY_CODE = LCT.CURRENCY_CODE
AND LCT.LANGUAGE = USERENV('LANG')
AND H.PAYMENT_METHOD_CODE = LOOK1.LOOKUP_CODE
AND LOOK1.LOOKUP_TYPE = 'OKL_AP_PAYMENT_METHOD'
AND H.FUNDING_TYPE_CODE = LOOK2.LOOKUP_CODE
AND LOOK2.LOOKUP_TYPE = 'OKL_FUNDING_TYPE'
AND H.TRX_STATUS_CODE = LOOK3.LOOKUP_CODE
AND LOOK3.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND NVL(H.INVOICE_TYPE
, DECODE(H.FUNDING_TYPE_CODE
, 'SUPPLIER_RETENTION'
, 'CREDIT'
, 'STANDARD')) = LOOK4.LOOKUP_CODE
AND LOOK4.LOOKUP_TYPE = 'OKL_PAYABLES_INVOICE_TYPE'
AND H.PAY_GROUP_LOOKUP_CODE = LOOK5.LOOKUP_CODE (+)
AND LOOK5.LOOKUP_TYPE (+) = 'PAY GROUP'
AND H.IPPT_ID = TRM.TERM_ID (+)
AND H.FUNDING_TYPE_CODE <> 'ASSET_SUBSIDY'

Columns