View: PSB_ERROR_REQUESTS_V

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSB_ERROR_REQUESTS_V

View Text

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') )

Columns