View: CSF_CT_TASKS

Product:	CSF - Field Service
Description:	Base view of 'Tasks' block in CSFCTTKS form. Selects only tasks with source document 'Service Request'
Implementation/DBA Data:	APPS.CSF_CT_TASKS

View Text

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
, NVL(T.OPEN_FLAG
, 'N') 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
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_PARTY_SITES PS
, 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(+) = PS.LOCATION_ID
AND PS.PARTY_SITE_ID(+) = T.ADDRESS_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'

Columns