VIEW: APPS.AHL_WF_MAPPING_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)