VIEW: APPS.PSB_ERROR_REQUESTS_V

Source

View Text - Preformatted

SELECT PEM.CONCURRENT_REQUEST_ID, PEM.PROCESS_ID, PEM.SOURCE_PROCESS, FL.MEANING SOURCE_PROCESS_MEANING , DECODE(PEM.SOURCE_PROCESS, 'DATA_EXTRACT_VALIDATION',COMBO_T.NAME , 'VALIDATE_BUDGET_HIERARCHY',COMBO_T.NAME, 'WORKSHEET_CREATION' ,COMBO_T.NAME, 'POSITION_WORKSHEET_EXCEPTION' ,COMBO_T.NAME, 'CREATE_BUDGET_JOURNAL' ,COMBO_T.NAME , 'MOVE_TO_INTERFACE',COMBO_T.NAME, 'MOVE_TO_PSB',COMBO_T.NAME) PROCESS_NAME FROM (select distinct CONCURRENT_REQUEST_ID, PROCESS_ID, SOURCE_PROCESS FROM PSB_ERROR_MESSAGES) PEM, FND_LOOKUPS FL, (select BUDGET_GROUP_ID process_id , NAME name, 'dummy' WSC, BUDGET_GROUP_TYPE BGT, 'BG' TNAME from PSB_BUDGET_GROUPS union select DATA_EXTRACT_ID process_id, DATA_EXTRACT_NAME name, 'dummy' WSC, 'dummy' BGT, 'DE' TNAME from PSB_DATA_EXTRACTS union select WORKSHEET_ID process_id, NAME name, WS_CREATION_COMPLETE WSC, 'dummy' BGT, 'WS' TNAME from PSB_WORKSHEETS union select EXPORT_ID process_id, EXPORT_NAME name, 'dummy' WSC, 'dummy' BGT, 'WSI' TNAME from PSB_WORKSHEETS_I ) COMBO_T WHERE FL.LOOKUP_TYPE = 'PSB_ERROR_MESSAGE_SOURCE' AND FL.LOOKUP_CODE = PEM.SOURCE_PROCESS AND ( (PEM.SOURCE_PROCESS='DATA_EXTRACT_VALIDATION' AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID AND COMBO_T.TNAME = 'DE') OR (PEM.SOURCE_PROCESS='VALIDATE_BUDGET_HIERARCHY' AND COMBO_T.BGT ='R' AND COMBO_T.PROCESS_ID =PEM.PROCESS_ID AND COMBO_T.TNAME = 'BG') OR (PEM.SOURCE_PROCESS='POSITION_WORKSHEET_EXCEPTION' AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID AND COMBO_T.TNAME = 'WS') OR (PEM.SOURCE_PROCESS='CREATE_BUDGET_JOURNAL' AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID AND COMBO_T.TNAME = 'WS') OR (PEM.SOURCE_PROCESS='WORKSHEET_CREATION' AND COMBO_T.WSC= 'Y' AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID AND COMBO_T.TNAME = 'WS') OR (PEM.SOURCE_PROCESS='MOVE_TO_INTERFACE' AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID AND COMBO_T.TNAME = 'WSI') OR (PEM.SOURCE_PROCESS='MOVE_TO_PSB' AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID AND COMBO_T.TNAME = 'WSI') )

View Text - HTML Formatted

SELECT PEM.CONCURRENT_REQUEST_ID
, PEM.PROCESS_ID
, PEM.SOURCE_PROCESS
, FL.MEANING SOURCE_PROCESS_MEANING
, DECODE(PEM.SOURCE_PROCESS
, 'DATA_EXTRACT_VALIDATION'
, COMBO_T.NAME
, 'VALIDATE_BUDGET_HIERARCHY'
, COMBO_T.NAME
, 'WORKSHEET_CREATION'
, COMBO_T.NAME
, 'POSITION_WORKSHEET_EXCEPTION'
, COMBO_T.NAME
, 'CREATE_BUDGET_JOURNAL'
, COMBO_T.NAME
, 'MOVE_TO_INTERFACE'
, COMBO_T.NAME
, 'MOVE_TO_PSB'
, COMBO_T.NAME) PROCESS_NAME
FROM (SELECT DISTINCT CONCURRENT_REQUEST_ID
, PROCESS_ID
, SOURCE_PROCESS
FROM PSB_ERROR_MESSAGES) PEM
, FND_LOOKUPS FL
, (SELECT BUDGET_GROUP_ID PROCESS_ID
, NAME NAME
, 'DUMMY' WSC
, BUDGET_GROUP_TYPE BGT
, 'BG' TNAME
FROM PSB_BUDGET_GROUPS UNION SELECT DATA_EXTRACT_ID PROCESS_ID
, DATA_EXTRACT_NAME NAME
, 'DUMMY' WSC
, 'DUMMY' BGT
, 'DE' TNAME
FROM PSB_DATA_EXTRACTS UNION SELECT WORKSHEET_ID PROCESS_ID
, NAME NAME
, WS_CREATION_COMPLETE WSC
, 'DUMMY' BGT
, 'WS' TNAME
FROM PSB_WORKSHEETS UNION SELECT EXPORT_ID PROCESS_ID
, EXPORT_NAME NAME
, 'DUMMY' WSC
, 'DUMMY' BGT
, 'WSI' TNAME
FROM PSB_WORKSHEETS_I ) COMBO_T
WHERE FL.LOOKUP_TYPE = 'PSB_ERROR_MESSAGE_SOURCE'
AND FL.LOOKUP_CODE = PEM.SOURCE_PROCESS
AND ( (PEM.SOURCE_PROCESS='DATA_EXTRACT_VALIDATION'
AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID
AND COMBO_T.TNAME = 'DE') OR (PEM.SOURCE_PROCESS='VALIDATE_BUDGET_HIERARCHY'
AND COMBO_T.BGT ='R'
AND COMBO_T.PROCESS_ID =PEM.PROCESS_ID
AND COMBO_T.TNAME = 'BG') OR (PEM.SOURCE_PROCESS='POSITION_WORKSHEET_EXCEPTION'
AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID
AND COMBO_T.TNAME = 'WS') OR (PEM.SOURCE_PROCESS='CREATE_BUDGET_JOURNAL'
AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID
AND COMBO_T.TNAME = 'WS') OR (PEM.SOURCE_PROCESS='WORKSHEET_CREATION'
AND COMBO_T.WSC= 'Y'
AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID
AND COMBO_T.TNAME = 'WS') OR (PEM.SOURCE_PROCESS='MOVE_TO_INTERFACE'
AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID
AND COMBO_T.TNAME = 'WSI') OR (PEM.SOURCE_PROCESS='MOVE_TO_PSB'
AND COMBO_T.PROCESS_ID=PEM.PROCESS_ID
AND COMBO_T.TNAME = 'WSI') )