View: AHL_WF_MAPPING_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view stores the query to retrieve Work flow information
Implementation/DBA Data:	APPS.AHL_WF_MAPPING_V

View Text

SELECT DISTINCT AWM.WF_MAPPING_ID
, AWM.OBJECT_VERSION_NUMBER
, AWM.APPLICATION_USG_CODE
, APPUSG.MEANING "APPLICATION_USG"
, AWM.WF_PROCESS_NAME
, AWM.ACTIVE_FLAG
, AWM.APPROVAL_OBJECT
, WRPV.DISPLAY_NAME
, WRPV.ITEM_TYPE
FROM WF_RUNNABLE_PROCESSES_V WRPV
, AHL_WF_MAPPING AWM
, FND_LOOKUP_VALUES_VL APPUSG
WHERE UPPER(WRPV.ITEM_TYPE) = UPPER(AWM.ITEM_TYPE)
AND UPPER(WRPV.PROCESS_NAME) = UPPER(AWM.WF_PROCESS_NAME)
AND APPUSG.LOOKUP_TYPE (+) = 'AHL_APPLICATION_USAGE_CODE'
AND APPUSG.LOOKUP_CODE(+) = AWM.APPLICATION_USG_CODE UNION (SELECT DISTINCT AWM.WF_MAPPING_ID
, AWM.OBJECT_VERSION_NUMBER
, AWM.APPLICATION_USG_CODE
, APPUSG.MEANING "APPLICATION_USG"
, AWM.WF_PROCESS_NAME
, AWM.ACTIVE_FLAG
, AWM.APPROVAL_OBJECT
, ' ' DISPLAY_NAME
, AWM.ITEM_TYPE
FROM AHL_WF_MAPPING AWM
, FND_LOOKUP_VALUES_VL APPUSG
WHERE AWM.ITEM_TYPE IS NULL
AND AWM.WF_PROCESS_NAME IS NULL
AND APPUSG.LOOKUP_TYPE (+) = 'AHL_APPLICATION_USAGE_CODE'
AND APPUSG.LOOKUP_CODE(+) = AWM.APPLICATION_USG_CODE)

Columns