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.

[Home] [Help]

View: CSF_VALIDATE_TASKS_V

Product:	CSF - Field Service
Description:
Implementation/DBA Data:	APPS.CSF_VALIDATE_TASKS_V

View Text

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

Columns

Name
ROW_ID
TASK_ID
TASK_NUMBER
CUST_ACCOUNT_ID
CUSTOMER_ID
ADDRESS_ID
PARENT_TASK_ID
SOURCE_OBJECT_ID
SOURCE_OBJECT_NAME
SOURCE_OBJECT_TYPE_CODE
DURATION
DURATION_UOM
PLANNED_EFFORT
PLANNED_EFFORT_UOM
ACTUAL_EFFORT
ACTUAL_EFFORT_UOM
PLANNED_START_DATE
PLANNED_END_DATE
SCHEDULED_START_DATE
SCHEDULED_END_DATE
ACTUAL_START_DATE
ACTUAL_END_DATE
INCIDENT_ID
INCIDENT_NUMBER
TASK_NAME
TASK_STATUS
TASK_TYPE
TASK_PRIORITY
TASK_DESCRIPTION
INCIDENT_CUSTOMER_NUMBER
INCIDENT_CUSTOMER_NAME
LOCATION_ID
ADDRESS_STYLE
ADDRESS
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
ADDRESS_KEY
CITY
STATE
POSTAL_CODE
COUNTY
PROVINCE
COUNTRY
VALIDATED_FLAG
OVERRIDE_FLAG
LOG_DETAIL_SHORT
LOG_DETAIL_LONG
TIMEZONE_ID