View: IEU_UWQ_ESC_MYOWN_V

Product:	IEU - Universal Work Queue
Description:	View used for UWQ selector SpreadTable.
Implementation/DBA Data:	APPS.IEU_UWQ_ESC_MYOWN_V

View Text

SELECT B.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, B.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'ESCALATION_ID' IEU_PARAM_PK_COL
, TO_CHAR(ESCALATION_ID) IEU_PARAM_PK_VALUE
, A.RESOURCE_ID
, A.RESOURCE_TYPE
, ESCALATION_ID
, ESCALATION_NUMBER
, ESCALATION_NAME
, ESCALATION_STATUS
, OPEN_DATE
, TARGET_DATE
, OWNER_TYPE_CODE
, OWNER_ID
, OWNER
, CUSTOMER_NAME
, CUST_ACCOUNT_NUMBER
, ESCALATION_LEVEL
, ESCALATION_LEVEL_NAME
, REQUESTER_NAME
, A.OBJECT_NAME
, A.OBJECT_CODE
, A.REF_DOC_ID
, A.REF_DOC_NUMBER
FROM JTF_ESC_UWQ_V A
, JTF_OBJECTS_B B
WHERE B.OBJECT_CODE = 'ESC'

Columns