VIEW: APPS.IEU_UWQ_TASKS_MYOWN_V

Source

View Text - Preformatted

SELECT b.object_Function IEU_OBJECT_FUNCTION, b.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, a.owner_id Resource_id, a.owner_type_code Resource_type, a.Task_id, Task_Number, tasks_tl.Task_Name, typ.name Task_Type, sts_tl.name Task_Status, pri.name Task_Priority, Planned_Start_Date, Planned_End_Date, Scheduled_Start_Date, Scheduled_End_Date, Actual_Start_Date, Actual_End_Date, tl.name Source_Object_type, Source_Object_type_code, Source_Object_Id, parties.party_id customer_id, parties.party_name customer_name, global_timezone_name, tz.gmt_deviation_hours, duration, duration_uom, escalation_level, a.task_status_id, a.task_type_id, jtf_task_uwq_pvt.get_primary_phone( a.task_id) primary_phone, hcp.email_address primary_email, a.creation_date, a.last_update_date, a.source_object_type_code IEU_ACTION_OBJECT_CODE, tasks_tl.description, a.source_object_name source_document_name, a.object_version_number FROM jtf_tasks_b a, jtf_task_statuses_tl sts_tl, jtf_tasks_tl tasks_tl, jtf_objects_b b, jtf_objects_tl tl, jtf_task_priorities_tl pri, hz_timezones tz, jtf_task_types_tl typ, jtf_task_contacts jtc, hz_contact_points hcp, hz_parties parties WHERE a.source_object_type_code = b.object_code and a.task_type_id = typ.task_type_id and customer_id = parties.party_id(+) and typ.language=userenv('LANG') and a.task_id = tasks_tl.task_id and tasks_tl.language = userenv('lang') and (a.owner_type_code is null or a.owner_type_code not in ('RS_GROUP','RS_TEAM')) and tz.timezone_id(+) = a.timezone_id and b.object_code = tl.object_code and tl.language = userenv('lang') and a.task_priority_id = pri.task_priority_id (+) and pri.language(+) = userenv('LANG') and a.open_flag = 'Y' and a.TASK_STATUS_ID = sts_tl.TASK_STATUS_ID and sts_tl.LANGUAGE = userenv('LANG') and nvl(a.deleted_flag, 'N') <> 'Y' and a.entity = 'TASK' and jtc.task_id(+) = a.task_id AND jtc.primary_flag(+) = 'Y' AND hcp.owner_table_id(+) = jtc.contact_id AND hcp.owner_table_name(+) = 'HZ_PARTIES' AND hcp.contact_point_type(+) = 'EMAIL' AND hcp.primary_flag(+) = 'Y'

View Text - HTML Formatted

SELECT B.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, B.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
, A.OWNER_ID RESOURCE_ID
, A.OWNER_TYPE_CODE RESOURCE_TYPE
, A.TASK_ID
, TASK_NUMBER
, TASKS_TL.TASK_NAME
, TYP.NAME TASK_TYPE
, STS_TL.NAME TASK_STATUS
, PRI.NAME TASK_PRIORITY
, PLANNED_START_DATE
, PLANNED_END_DATE
, SCHEDULED_START_DATE
, SCHEDULED_END_DATE
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, TL.NAME SOURCE_OBJECT_TYPE
, SOURCE_OBJECT_TYPE_CODE
, SOURCE_OBJECT_ID
, PARTIES.PARTY_ID CUSTOMER_ID
, PARTIES.PARTY_NAME CUSTOMER_NAME
, GLOBAL_TIMEZONE_NAME
, TZ.GMT_DEVIATION_HOURS
, DURATION
, DURATION_UOM
, ESCALATION_LEVEL
, A.TASK_STATUS_ID
, A.TASK_TYPE_ID
, JTF_TASK_UWQ_PVT.GET_PRIMARY_PHONE( A.TASK_ID) PRIMARY_PHONE
, HCP.EMAIL_ADDRESS PRIMARY_EMAIL
, A.CREATION_DATE
, A.LAST_UPDATE_DATE
, A.SOURCE_OBJECT_TYPE_CODE IEU_ACTION_OBJECT_CODE
, TASKS_TL.DESCRIPTION
, A.SOURCE_OBJECT_NAME SOURCE_DOCUMENT_NAME
, A.OBJECT_VERSION_NUMBER
FROM JTF_TASKS_B A
, JTF_TASK_STATUSES_TL STS_TL
, JTF_TASKS_TL TASKS_TL
, JTF_OBJECTS_B B
, JTF_OBJECTS_TL TL
, JTF_TASK_PRIORITIES_TL PRI
, HZ_TIMEZONES TZ
, JTF_TASK_TYPES_TL TYP
, JTF_TASK_CONTACTS JTC
, HZ_CONTACT_POINTS HCP
, HZ_PARTIES PARTIES
WHERE A.SOURCE_OBJECT_TYPE_CODE = B.OBJECT_CODE
AND A.TASK_TYPE_ID = TYP.TASK_TYPE_ID
AND CUSTOMER_ID = PARTIES.PARTY_ID(+)
AND TYP.LANGUAGE=USERENV('LANG')
AND A.TASK_ID = TASKS_TL.TASK_ID
AND TASKS_TL.LANGUAGE = USERENV('LANG')
AND (A.OWNER_TYPE_CODE IS NULL OR A.OWNER_TYPE_CODE NOT IN ('RS_GROUP'
, 'RS_TEAM'))
AND TZ.TIMEZONE_ID(+) = A.TIMEZONE_ID
AND B.OBJECT_CODE = TL.OBJECT_CODE
AND TL.LANGUAGE = USERENV('LANG')
AND A.TASK_PRIORITY_ID = PRI.TASK_PRIORITY_ID (+)
AND PRI.LANGUAGE(+) = USERENV('LANG')
AND A.OPEN_FLAG = 'Y'
AND A.TASK_STATUS_ID = STS_TL.TASK_STATUS_ID
AND STS_TL.LANGUAGE = USERENV('LANG')
AND NVL(A.DELETED_FLAG
, 'N') <> 'Y'
AND A.ENTITY = 'TASK'
AND JTC.TASK_ID(+) = A.TASK_ID
AND JTC.PRIMARY_FLAG(+) = 'Y'
AND HCP.OWNER_TABLE_ID(+) = JTC.CONTACT_ID
AND HCP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND HCP.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND HCP.PRIMARY_FLAG(+) = 'Y'