VIEW: APPS.IEU_UWQ_TASKS_SEC_V

Source

View Text - Preformatted

SELECT a.object_Function IEU_OBJECT_FUNCTION, a.object_parameters IEU_OBJECT_PARAMETERS, '' IEU_MEDIA_TYPE_UUID, 'Source_Object_id' IEU_PARAM_PK_COL, to_char(Source_object_id) IEU_PARAM_PK_VALUE, Resource_id, Resource_type, Task_id, Task_Number, Task_Name, Task_Type, Task_Status, Task_Priority, Planned_Start_Date, Planned_End_Date, Scheduled_Start_Date, Scheduled_End_Date, Actual_Start_Date, Actual_End_Date, Source_Object_type, Source_Object_type_code, Source_Object_Id, Owner_id, owner_type_code, Owner, Customer_name, cust_account_number, global_timezone_name, gmt_deviation_hours, duration, duration_uom, escalation_level, escalation_owner, owned_flag, task_status_id, task_type_id, closed_flag, lu.meaning own_assign_label, a.source_object_type_code IEU_ACTION_OBJECT_CODE, assignee_role FROM jtf_task_uwq_v a, fnd_lookup_values_vl lu WHERE lu.lookup_type = 'IEU_NODE_LABELS' and lu.view_application_id = 696 and lu.lookup_code = a.owned_flag and nvl(a.source_object_type_code,'X') <> 'SR' UNION ALL SELECT a.object_Function IEU_OBJECT_FUNCTION, a.object_parameters IEU_OBJECT_PARAMETERS, '' IEU_MEDIA_TYPE_UUID, 'Source_Object_id' IEU_PARAM_PK_COL, to_char(Source_object_id) IEU_PARAM_PK_VALUE, Resource_id, Resource_type, Task_id, Task_Number, Task_Name, Task_Type, Task_Status, Task_Priority, Planned_Start_Date, Planned_End_Date, Scheduled_Start_Date, Scheduled_End_Date, Actual_Start_Date, Actual_End_Date, Source_Object_type, Source_Object_type_code, Source_Object_Id, Owner_id, owner_type_code, Owner, Customer_name, cust_account_number, global_timezone_name, gmt_deviation_hours, duration, duration_uom, escalation_level, escalation_owner, owned_flag, task_status_id, task_type_id, closed_flag, lu.meaning own_assign_label, a.source_object_type_code IEU_ACTION_OBJECT_CODE, assignee_role FROM jtf_task_uwq_v a, fnd_lookup_values_vl lu WHERE lu.lookup_type = 'IEU_NODE_LABELS' and lu.view_application_id = 696 and lu.lookup_code = a.owned_flag and a.source_object_type_code = 'SR' and exists (select 'X' from cs_incidents_b_sec sr where sr.incident_id =a.source_object_id)

View Text - HTML Formatted

SELECT A.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, A.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'SOURCE_OBJECT_ID' IEU_PARAM_PK_COL
, TO_CHAR(SOURCE_OBJECT_ID) IEU_PARAM_PK_VALUE
, RESOURCE_ID
, RESOURCE_TYPE
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, TASK_TYPE
, TASK_STATUS
, TASK_PRIORITY
, PLANNED_START_DATE
, PLANNED_END_DATE
, SCHEDULED_START_DATE
, SCHEDULED_END_DATE
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, SOURCE_OBJECT_TYPE
, SOURCE_OBJECT_TYPE_CODE
, SOURCE_OBJECT_ID
, OWNER_ID
, OWNER_TYPE_CODE
, OWNER
, CUSTOMER_NAME
, CUST_ACCOUNT_NUMBER
, GLOBAL_TIMEZONE_NAME
, GMT_DEVIATION_HOURS
, DURATION
, DURATION_UOM
, ESCALATION_LEVEL
, ESCALATION_OWNER
, OWNED_FLAG
, TASK_STATUS_ID
, TASK_TYPE_ID
, CLOSED_FLAG
, LU.MEANING OWN_ASSIGN_LABEL
, A.SOURCE_OBJECT_TYPE_CODE IEU_ACTION_OBJECT_CODE
, ASSIGNEE_ROLE
FROM JTF_TASK_UWQ_V A
, FND_LOOKUP_VALUES_VL LU
WHERE LU.LOOKUP_TYPE = 'IEU_NODE_LABELS'
AND LU.VIEW_APPLICATION_ID = 696
AND LU.LOOKUP_CODE = A.OWNED_FLAG
AND NVL(A.SOURCE_OBJECT_TYPE_CODE
, 'X') <> 'SR' UNION ALL SELECT A.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, A.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'SOURCE_OBJECT_ID' IEU_PARAM_PK_COL
, TO_CHAR(SOURCE_OBJECT_ID) IEU_PARAM_PK_VALUE
, RESOURCE_ID
, RESOURCE_TYPE
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, TASK_TYPE
, TASK_STATUS
, TASK_PRIORITY
, PLANNED_START_DATE
, PLANNED_END_DATE
, SCHEDULED_START_DATE
, SCHEDULED_END_DATE
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, SOURCE_OBJECT_TYPE
, SOURCE_OBJECT_TYPE_CODE
, SOURCE_OBJECT_ID
, OWNER_ID
, OWNER_TYPE_CODE
, OWNER
, CUSTOMER_NAME
, CUST_ACCOUNT_NUMBER
, GLOBAL_TIMEZONE_NAME
, GMT_DEVIATION_HOURS
, DURATION
, DURATION_UOM
, ESCALATION_LEVEL
, ESCALATION_OWNER
, OWNED_FLAG
, TASK_STATUS_ID
, TASK_TYPE_ID
, CLOSED_FLAG
, LU.MEANING OWN_ASSIGN_LABEL
, A.SOURCE_OBJECT_TYPE_CODE IEU_ACTION_OBJECT_CODE
, ASSIGNEE_ROLE
FROM JTF_TASK_UWQ_V A
, FND_LOOKUP_VALUES_VL LU
WHERE LU.LOOKUP_TYPE = 'IEU_NODE_LABELS'
AND LU.VIEW_APPLICATION_ID = 696
AND LU.LOOKUP_CODE = A.OWNED_FLAG
AND A.SOURCE_OBJECT_TYPE_CODE = 'SR'
AND EXISTS (SELECT 'X'
FROM CS_INCIDENTS_B_SEC SR
WHERE SR.INCIDENT_ID =A.SOURCE_OBJECT_ID)