VIEW: APPS.OKL_CURE_REQUEST_LIST_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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