eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CSF_CT_TASKS

Source

View Text - Preformatted


SELECT t.rowid row_id , t.task_id , t.created_by , t.creation_date , t.last_updated_by , t.last_update_date , t.last_update_login , t.task_number , t.task_type_id , t.task_status_id , t.task_priority_id , t.owner_id , t.owner_type_code , t.assigned_by_id , t.cust_account_id , t.customer_id , t.address_id , t.parent_task_id , t.source_object_type_code , t.timezone_id , t.source_object_id , t.source_object_name , 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 , tl.task_name , tl.description , t.object_version_number , t.owner_territory_id , tsl.name task_status , nvl(ts.schedulable_flag,'N') status_schedulable_flag , ttl.name task_type , nvl(tt.schedule_flag,'N') type_schedulable_flag , tp.name task_priority , t.org_id , i.incident_id , i.incident_number , i.customer_id incident_customer_id , i.account_id incident_account_id , i.creation_date incident_creation_date , i.contract_service_id , i.incident_urgency_id , i.obligation_date , i.problem_code , i.resolution_code , i.customer_product_id , i.current_serial_number , i.product_revision , i.inv_item_revision , i.inventory_item_id , i.inv_organization_id , decode(i.customer_product_id,null,null,'Y') installed_base_flag , il.summary , pi.party_name incident_customer_name , si.concatenated_segments product_name , si.description product_description , si.revision_qty_control_code , l.location_id , l.address1 , l.address2 , l.postal_code , l.city , l.state , l.province , l.country ,l.address3 ,l.address4 ,l.county ,t.task_split_flag ,pi.party_number ,nvl(ts.closed_flag,'N') closed_flag ,nvl(ts.assigned_flag,'N') assigned_flag ,it. incident_type_id incident_type_id ,it.name incident_type_name ,t.open_flag open_flag ,nvl(ts.start_date_type,'N') start_date_type ,nvl(ts.end_date_type,'N') end_date_type ,l.timezone_id task_timezone_id, nvl(ts.working_flag,'N') working_flag, nvl(ts.rejected_flag,'N') rejected_flag, nvl(ts.completed_flag,'N') completed_flag FROM jtf_tasks_b t , jtf_tasks_tl tl , jtf_task_priorities_tl tp , jtf_task_types_b tt , jtf_task_types_tl ttl , jtf_task_statuses_b ts , jtf_task_statuses_tl tsl , hz_locations l , cs_incidents_all_b i , cs_incidents_all_tl il , hz_parties pi , mtl_system_items_kfv si , cs_incident_types_tl it WHERE si.inventory_item_id(+) = i.inventory_item_id and si.organization_id(+) = i.inv_organization_id and pi.party_id(+) = i.customer_id and it.LANGUAGE = USERENV ('lang') and it.incident_type_id = i.incident_type_id and il.language = userenv('lang') and il.incident_id = t.source_object_id and i.incident_id = t.source_object_id and l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id) and tsl.language = userenv('lang') and tsl.task_status_id = t.task_status_id and ts.usage = 'TASK' and ts.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 tl.language = userenv('lang') and tl.task_id = t.task_id and nvl(t.deleted_flag, 'N') <> 'Y' and t.source_object_type_code = 'SR' and (t.planned_start_date + 0 = t.planned_start_date or t.planned_start_date is null) and i.creation_date + 0 = i.creation_date and (nvl(t.task_split_flag,'N') <> 'D' or nvl(ts.cancelled_flag,'N') <> 'Y')

View Text - HTML Formatted

SELECT T.ROWID ROW_ID
, T.TASK_ID
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
, T.TASK_NUMBER
, T.TASK_TYPE_ID
, T.TASK_STATUS_ID
, T.TASK_PRIORITY_ID
, T.OWNER_ID
, T.OWNER_TYPE_CODE
, T.ASSIGNED_BY_ID
, T.CUST_ACCOUNT_ID
, T.CUSTOMER_ID
, T.ADDRESS_ID
, T.PARENT_TASK_ID
, T.SOURCE_OBJECT_TYPE_CODE
, T.TIMEZONE_ID
, T.SOURCE_OBJECT_ID
, T.SOURCE_OBJECT_NAME
, 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
, TL.TASK_NAME
, TL.DESCRIPTION
, T.OBJECT_VERSION_NUMBER
, T.OWNER_TERRITORY_ID
, TSL.NAME TASK_STATUS
, NVL(TS.SCHEDULABLE_FLAG
, 'N') STATUS_SCHEDULABLE_FLAG
, TTL.NAME TASK_TYPE
, NVL(TT.SCHEDULE_FLAG
, 'N') TYPE_SCHEDULABLE_FLAG
, TP.NAME TASK_PRIORITY
, T.ORG_ID
, I.INCIDENT_ID
, I.INCIDENT_NUMBER
, I.CUSTOMER_ID INCIDENT_CUSTOMER_ID
, I.ACCOUNT_ID INCIDENT_ACCOUNT_ID
, I.CREATION_DATE INCIDENT_CREATION_DATE
, I.CONTRACT_SERVICE_ID
, I.INCIDENT_URGENCY_ID
, I.OBLIGATION_DATE
, I.PROBLEM_CODE
, I.RESOLUTION_CODE
, I.CUSTOMER_PRODUCT_ID
, I.CURRENT_SERIAL_NUMBER
, I.PRODUCT_REVISION
, I.INV_ITEM_REVISION
, I.INVENTORY_ITEM_ID
, I.INV_ORGANIZATION_ID
, DECODE(I.CUSTOMER_PRODUCT_ID
, NULL
, NULL
, 'Y') INSTALLED_BASE_FLAG
, IL.SUMMARY
, PI.PARTY_NAME INCIDENT_CUSTOMER_NAME
, SI.CONCATENATED_SEGMENTS PRODUCT_NAME
, SI.DESCRIPTION PRODUCT_DESCRIPTION
, SI.REVISION_QTY_CONTROL_CODE
, L.LOCATION_ID
, L.ADDRESS1
, L.ADDRESS2
, L.POSTAL_CODE
, L.CITY
, L.STATE
, L.PROVINCE
, L.COUNTRY
, L.ADDRESS3
, L.ADDRESS4
, L.COUNTY
, T.TASK_SPLIT_FLAG
, PI.PARTY_NUMBER
, NVL(TS.CLOSED_FLAG
, 'N') CLOSED_FLAG
, NVL(TS.ASSIGNED_FLAG
, 'N') ASSIGNED_FLAG
, IT. INCIDENT_TYPE_ID INCIDENT_TYPE_ID
, IT.NAME INCIDENT_TYPE_NAME
, T.OPEN_FLAG OPEN_FLAG
, NVL(TS.START_DATE_TYPE
, 'N') START_DATE_TYPE
, NVL(TS.END_DATE_TYPE
, 'N') END_DATE_TYPE
, L.TIMEZONE_ID TASK_TIMEZONE_ID
, NVL(TS.WORKING_FLAG
, 'N') WORKING_FLAG
, NVL(TS.REJECTED_FLAG
, 'N') REJECTED_FLAG
, NVL(TS.COMPLETED_FLAG
, 'N') COMPLETED_FLAG
FROM JTF_TASKS_B T
, JTF_TASKS_TL TL
, JTF_TASK_PRIORITIES_TL TP
, JTF_TASK_TYPES_B TT
, JTF_TASK_TYPES_TL TTL
, JTF_TASK_STATUSES_B TS
, JTF_TASK_STATUSES_TL TSL
, HZ_LOCATIONS L
, CS_INCIDENTS_ALL_B I
, CS_INCIDENTS_ALL_TL IL
, HZ_PARTIES PI
, MTL_SYSTEM_ITEMS_KFV SI
, CS_INCIDENT_TYPES_TL IT
WHERE SI.INVENTORY_ITEM_ID(+) = I.INVENTORY_ITEM_ID
AND SI.ORGANIZATION_ID(+) = I.INV_ORGANIZATION_ID
AND PI.PARTY_ID(+) = I.CUSTOMER_ID
AND IT.LANGUAGE = USERENV ('LANG')
AND IT.INCIDENT_TYPE_ID = I.INCIDENT_TYPE_ID
AND IL.LANGUAGE = USERENV('LANG')
AND IL.INCIDENT_ID = T.SOURCE_OBJECT_ID
AND I.INCIDENT_ID = T.SOURCE_OBJECT_ID
AND L.LOCATION_ID(+) = CSF_TASKS_PUB.GET_TASK_LOCATION_ID(T.TASK_ID
, T.ADDRESS_ID
, T.LOCATION_ID)
AND TSL.LANGUAGE = USERENV('LANG')
AND TSL.TASK_STATUS_ID = T.TASK_STATUS_ID
AND TS.USAGE = 'TASK'
AND TS.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 TL.LANGUAGE = USERENV('LANG')
AND TL.TASK_ID = T.TASK_ID
AND NVL(T.DELETED_FLAG
, 'N') <> 'Y'
AND T.SOURCE_OBJECT_TYPE_CODE = 'SR'
AND (T.PLANNED_START_DATE + 0 = T.PLANNED_START_DATE OR T.PLANNED_START_DATE IS NULL)
AND I.CREATION_DATE + 0 = I.CREATION_DATE
AND (NVL(T.TASK_SPLIT_FLAG
, 'N') <> 'D' OR NVL(TS.CANCELLED_FLAG
, 'N') <> 'Y')