Product: | OKL - Lease and Finance Management |
---|---|
Description: | View for cure requests |
Implementation/DBA Data: | APPS.OKL_CURE_REQUEST_LIST_UV |
SELECT CRT.CURE_REPORT_ID CURE_REPORT_ID
, CRT.REPORT_NUMBER REPORT_NUMBER
, CRT.REPORT_TYPE REPORT_TYPE
, CRT.REPORT_DATE REPORT_DATE
, CRT.VENDOR_ID VENDOR_ID
, CRT.VENDOR_SITE_ID VENDOR_SITE_ID
, CRT.VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, CRT.APPROVAL_STATUS APPROVAL_STATUS
, CRT.APPROVAL_REASON APPROVAL_REASON
, CRT.EXPIRATION_DATE EXPIRATION_DATE
, CRT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CRT.CURRENCY_CODE CURRENCY_CODE
, CRT.ORG_ID ORG_ID
, CRT.REQUEST_ID REQUEST_ID
, CRT.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CRT.PROGRAM_ID PROGRAM_ID
, CRT.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CRT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CRT.ATTRIBUTE1 ATTRIBUTE1
, CRT.ATTRIBUTE2 ATTRIBUTE2
, CRT.ATTRIBUTE3 ATTRIBUTE3
, CRT.ATTRIBUTE4 ATTRIBUTE4
, CRT.ATTRIBUTE5 ATTRIBUTE5
, CRT.ATTRIBUTE6 ATTRIBUTE6
, CRT.ATTRIBUTE7 ATTRIBUTE7
, CRT.ATTRIBUTE8 ATTRIBUTE8
, CRT.ATTRIBUTE9 ATTRIBUTE9
, CRT.ATTRIBUTE10 ATTRIBUTE10
, CRT.ATTRIBUTE11 ATTRIBUTE11
, CRT.ATTRIBUTE12 ATTRIBUTE12
, CRT.ATTRIBUTE13 ATTRIBUTE13
, CRT.ATTRIBUTE14 ATTRIBUTE14
, CRT.ATTRIBUTE15 ATTRIBUTE15
, CRT.CREATED_BY CREATED_BY
, CRT.CREATION_DATE CREATION_DATE
, CRT.LAST_UPDATED_BY LAST_UPDATED_BY
, CRT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CRT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FND.MEANING APPROVAL_STATUS_MEANING
, VEN.VENDOR_NAME VENDOR_NAME
, REQ.MEANING REPORT_TYPE_MEANING
FROM FND_LOOKUPS REQ
, OKL_CURE_REPORTS CRT
, FND_LOOKUPS FND
, PO_VENDORS VEN
WHERE CRT.VENDOR_ID = VEN.VENDOR_ID
AND CRT.APPROVAL_STATUS = FND.LOOKUP_CODE
AND FND. LOOKUP_TYPE = 'OKL_CURE_REQUEST_APPROVE_STATU'
AND CRT.REPORT_TYPE = REQ.LOOKUP_CODE
AND REQ.LOOKUP_TYPE = 'OKL_CURE_REQUEST_TYPE' ORDER BY CRT.REPORT_DATE DESC