[Home] [Help]
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
Name |
IEU_OBJECT_FUNCTION |
IEU_OBJECT_PARAMETERS |
IEU_MEDIA_TYPE_UUID |
IEU_PARAM_PK_COL |
IEU_PARAM_PK_VALUE |
RESOURCE_ID |
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 |
OBJECT_NAME |
OBJECT_CODE |
REF_DOC_ID |
REF_DOC_NUMBER |