eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGC_SLA_CC_PO_PA_V

Source

View Text - Preformatted


SELECT CCHD.CC_HEADER_ID CC_HEADER_ID , CCHD.ORG_ID ORG_ID , 'CC' DOCUMENT_TYPE , CCHD.CC_TYPE HEADER_TYPE , CCHD.CC_NUM DOC_NUM , CCHD.CC_VERSION_NUM VERSION_NUM , CCHD.CC_START_DATE TRANSACTION_DATE FROM IGC_CC_HEADERS_ALL CCHD UNION ALL SELECT REQUISITION_HEADER_ID , ORG_ID , 'REQ' , TYPE_LOOKUP_CODE , SEGMENT1 , 0 , START_DATE_ACTIVE FROM PO_REQUISITION_HEADERS_ALL POH UNION ALL SELECT PO_HEADER_ID , ORG_ID , 'PO' , TYPE_LOOKUP_CODE , SEGMENT1 , REVISION_NUM , START_DATE_ACTIVE FROM PO_HEADERS_ALL PO UNION ALL SELECT BUD.BUDGET_VERSION_ID , PROJ.ORG_ID , 'PA' , PROJ.PROJECT_TYPE , PROJ.SEGMENT1 , 1 , PROJ.START_DATE FROM PA_BUDGET_VERSIONS BUD, PA_PROJECTS_ALL PROJ WHERE PROJ.PROJECT_ID = BUD.PROJECT_ID

View Text - HTML Formatted

SELECT CCHD.CC_HEADER_ID CC_HEADER_ID
, CCHD.ORG_ID ORG_ID
, 'CC' DOCUMENT_TYPE
, CCHD.CC_TYPE HEADER_TYPE
, CCHD.CC_NUM DOC_NUM
, CCHD.CC_VERSION_NUM VERSION_NUM
, CCHD.CC_START_DATE TRANSACTION_DATE
FROM IGC_CC_HEADERS_ALL CCHD UNION ALL SELECT REQUISITION_HEADER_ID
, ORG_ID
, 'REQ'
, TYPE_LOOKUP_CODE
, SEGMENT1
, 0
, START_DATE_ACTIVE
FROM PO_REQUISITION_HEADERS_ALL POH UNION ALL SELECT PO_HEADER_ID
, ORG_ID
, 'PO'
, TYPE_LOOKUP_CODE
, SEGMENT1
, REVISION_NUM
, START_DATE_ACTIVE
FROM PO_HEADERS_ALL PO UNION ALL SELECT BUD.BUDGET_VERSION_ID
, PROJ.ORG_ID
, 'PA'
, PROJ.PROJECT_TYPE
, PROJ.SEGMENT1
, 1
, PROJ.START_DATE
FROM PA_BUDGET_VERSIONS BUD
, PA_PROJECTS_ALL PROJ
WHERE PROJ.PROJECT_ID = BUD.PROJECT_ID