VIEW: APPS.CSF_VALIDATE_TASKS_V

Source

View Text - Preformatted

SELECT t.ROWID row_id, t.task_id, t.task_number, t.cust_account_id, t.customer_id, t.address_id, t.parent_task_id, t.source_object_id, t.source_object_name, t.source_object_type_code, t.DURATION, t.duration_uom, t.planned_effort, t.planned_effort_uom, t.actual_effort, t.actual_effort_uom, t.planned_start_date, t.planned_end_date, t.scheduled_start_date, t.scheduled_end_date, t.actual_start_date, t.actual_end_date, i.incident_id, i.incident_number, tl.task_name, tsl.NAME task_status, ttl.NAME, tp.NAME task_priority, tl.description, pi.party_number, pi.party_name, hl.location_id, hl.address_style, (hl.address1 || ', ' || hl.city || ', ' || hl.state || ', ' || hl.postal_code || ', ' || hl.country ), hl.address1, hl.address2, hl.address3, hl.address4, hl.address_key, hl.city, hl.state, hl.postal_code, hl.county, hl.province, hl.country, cl.validated_flag, cl.override_flag, cl.log_detail_short, cl.log_detail_long, hl.timezone_id FROM jtf_tasks_b t, hz_locations hl, csf_ext_locations cl, jtf_tasks_tl tl, jtf_task_statuses_tl tsl, jtf_task_types_b tt, jtf_task_types_tl ttl, jtf_task_priorities_tl tp, jtf_task_statuses_b ts, cs_incidents_all_b i, hz_parties pi WHERE t.source_object_type_code = 'SR' AND NVL (t.deleted_flag, 'N') <> 'Y' AND tl.LANGUAGE = USERENV ('LANG') AND tl.task_id = t.task_id AND NVL (ts.schedulable_flag, 'N') = 'Y' AND ts.USAGE = 'TASK' AND ts.task_status_id = t.task_status_id AND tsl.LANGUAGE = USERENV ('LANG') AND tsl.task_status_id = t.task_status_id AND ttl.LANGUAGE = USERENV ('LANG') AND ttl.task_type_id = t.task_type_id AND tt.task_type_id = t.task_type_id AND tp.LANGUAGE(+) = USERENV ('LANG') AND tp.task_priority_id(+) = t.task_priority_id AND hl.location_id = csf_tasks_pub.get_task_location_id (t.task_id, t.address_id, t.location_id) AND i.incident_id = t.source_object_id AND pi.party_id = i.customer_id AND cl.task_id = t.task_id

View Text - HTML Formatted

SELECT T.ROWID ROW_ID
, T.TASK_ID
, T.TASK_NUMBER
, T.CUST_ACCOUNT_ID
, T.CUSTOMER_ID
, T.ADDRESS_ID
, T.PARENT_TASK_ID
, T.SOURCE_OBJECT_ID
, T.SOURCE_OBJECT_NAME
, T.SOURCE_OBJECT_TYPE_CODE
, T.DURATION
, T.DURATION_UOM
, T.PLANNED_EFFORT
, T.PLANNED_EFFORT_UOM
, T.ACTUAL_EFFORT
, T.ACTUAL_EFFORT_UOM
, T.PLANNED_START_DATE
, T.PLANNED_END_DATE
, T.SCHEDULED_START_DATE
, T.SCHEDULED_END_DATE
, T.ACTUAL_START_DATE
, T.ACTUAL_END_DATE
, I.INCIDENT_ID
, I.INCIDENT_NUMBER
, TL.TASK_NAME
, TSL.NAME TASK_STATUS
, TTL.NAME
, TP.NAME TASK_PRIORITY
, TL.DESCRIPTION
, PI.PARTY_NUMBER
, PI.PARTY_NAME
, HL.LOCATION_ID
, HL.ADDRESS_STYLE
, (HL.ADDRESS1 || '
, ' || HL.CITY || '
, ' || HL.STATE || '
, ' || HL.POSTAL_CODE || '
, ' || HL.COUNTRY )
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.ADDRESS_KEY
, HL.CITY
, HL.STATE
, HL.POSTAL_CODE
, HL.COUNTY
, HL.PROVINCE
, HL.COUNTRY
, CL.VALIDATED_FLAG
, CL.OVERRIDE_FLAG
, CL.LOG_DETAIL_SHORT
, CL.LOG_DETAIL_LONG
, HL.TIMEZONE_ID
FROM JTF_TASKS_B T
, HZ_LOCATIONS HL
, CSF_EXT_LOCATIONS CL
, JTF_TASKS_TL TL
, JTF_TASK_STATUSES_TL TSL
, JTF_TASK_TYPES_B TT
, JTF_TASK_TYPES_TL TTL
, JTF_TASK_PRIORITIES_TL TP
, JTF_TASK_STATUSES_B TS
, CS_INCIDENTS_ALL_B I
, HZ_PARTIES PI
WHERE T.SOURCE_OBJECT_TYPE_CODE = 'SR'
AND NVL (T.DELETED_FLAG
, 'N') <> 'Y'
AND TL.LANGUAGE = USERENV ('LANG')
AND TL.TASK_ID = T.TASK_ID
AND NVL (TS.SCHEDULABLE_FLAG
, 'N') = 'Y'
AND TS.USAGE = 'TASK'
AND TS.TASK_STATUS_ID = T.TASK_STATUS_ID
AND TSL.LANGUAGE = USERENV ('LANG')
AND TSL.TASK_STATUS_ID = T.TASK_STATUS_ID
AND TTL.LANGUAGE = USERENV ('LANG')
AND TTL.TASK_TYPE_ID = T.TASK_TYPE_ID
AND TT.TASK_TYPE_ID = T.TASK_TYPE_ID
AND TP.LANGUAGE(+) = USERENV ('LANG')
AND TP.TASK_PRIORITY_ID(+) = T.TASK_PRIORITY_ID
AND HL.LOCATION_ID = CSF_TASKS_PUB.GET_TASK_LOCATION_ID (T.TASK_ID
, T.ADDRESS_ID
, T.LOCATION_ID)
AND I.INCIDENT_ID = T.SOURCE_OBJECT_ID
AND PI.PARTY_ID = I.CUSTOMER_ID
AND CL.TASK_ID = T.TASK_ID