VIEW: APPS.JTF_ESCALATION_TASK_V

Source

View Text - Preformatted

SELECT T.ROW_ID , T.TASK_ID , T.TASK_NUMBER, T.OBJECT_VERSION_NUMBER, T.OWNER_ID , T.OWNER_TYPE_CODE, JTOT.NAME OWNER_TYPE, T.OWNER_TERRITORY_ID , T.CREATED_BY , T.CREATION_DATE , T.LAST_UPDATED_BY , T.LAST_UPDATE_DATE , T.LAST_UPDATE_LOGIN , T.TASK_NAME , T.DESCRIPTION ,T.TASK_TYPE_ID , T.TASK_STATUS_ID , S.NAME STATUS_NAME , T.ESCALATION_LEVEL , L.MEANING, T.REASON_CODE , R.MEANING , T.CUSTOMER_ID , P.PARTY_NAME , T.CUST_ACCOUNT_ID , A.ACCOUNT_NUMBER ,T.ADDRESS_ID , L.CITY , T.PARENT_TASK_ID , T.DELETED_FLAG , T.ACTUAL_START_DATE , T.ACTUAL_END_DATE , T.SOURCE_OBJECT_TYPE_CODE , T.SOURCE_OBJECT_ID , T.SOURCE_OBJECT_NAME , T.TASK_PRIORITY_ID , T.ASSIGNED_BY_ID ,T.PRIVATE_FLAG , T.PUBLISH_FLAG , T.WORKFLOW_PROCESS_ID , T.PLANNED_END_DATE , T.ATTRIBUTE1 , T.ATTRIBUTE2 , T.ATTRIBUTE3 , T.ATTRIBUTE4 , T.ATTRIBUTE5 , T.ATTRIBUTE6 , T.ATTRIBUTE7 , T.ATTRIBUTE8 , T.ATTRIBUTE9 , T.ATTRIBUTE10 , T.ATTRIBUTE11 , T.ATTRIBUTE12 , T.ATTRIBUTE13 , T.ATTRIBUTE14 , T.ATTRIBUTE15 , T.ATTRIBUTE_CATEGORY FROM JTF_TASKS_VL T, HZ_PARTIES P, HZ_LOCATIONS L, HZ_CUST_ACCOUNTS A, JTF_EC_STATUSES_VL S, HZ_PARTY_SITES PS, (SELECT MEANING, LOOKUP_CODE FROM fnd_lookups WHERE LOOKUP_TYPE ='JTF_TASK_REASON_CODES' AND ENABLED_FLAG='Y' AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE)) R, (SELECT MEANING, LOOKUP_CODE FROM fnd_lookups WHERE LOOKUP_TYPE ='JTF_TASK_ESC_LEVEL' AND ENABLED_FLAG='Y' AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE)) L , JTF_OBJECTS_TL JTOT WHERE T.TASK_TYPE_ID=22 AND NVL(T.DELETED_FLAG,'N') = 'N' AND T.CUSTOMER_ID=P.PARTY_ID(+) AND T.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID(+) AND T.ADDRESS_ID = PS.PARTY_SITE_ID(+) AND T.ESCALATION_LEVEL = L.LOOKUP_CODE(+) AND T.REASON_CODE = R.LOOKUP_CODE(+) AND PS.LOCATION_ID = L.LOCATION_ID(+) AND T.TASK_STATUS_ID=S.TASK_STATUS_ID(+) AND T.OWNER_TYPE_CODE = JTOT.OBJECT_CODE(+) AND JTOT.LANGUAGE = USERENV('lang')

View Text - HTML Formatted

SELECT T.ROW_ID
, T.TASK_ID
, T.TASK_NUMBER
, T.OBJECT_VERSION_NUMBER
, T.OWNER_ID
, T.OWNER_TYPE_CODE
, JTOT.NAME OWNER_TYPE
, T.OWNER_TERRITORY_ID
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
, T.TASK_NAME
, T.DESCRIPTION
, T.TASK_TYPE_ID
, T.TASK_STATUS_ID
, S.NAME STATUS_NAME
, T.ESCALATION_LEVEL
, L.MEANING
, T.REASON_CODE
, R.MEANING
, T.CUSTOMER_ID
, P.PARTY_NAME
, T.CUST_ACCOUNT_ID
, A.ACCOUNT_NUMBER
, T.ADDRESS_ID
, L.CITY
, T.PARENT_TASK_ID
, T.DELETED_FLAG
, T.ACTUAL_START_DATE
, T.ACTUAL_END_DATE
, T.SOURCE_OBJECT_TYPE_CODE
, T.SOURCE_OBJECT_ID
, T.SOURCE_OBJECT_NAME
, T.TASK_PRIORITY_ID
, T.ASSIGNED_BY_ID
, T.PRIVATE_FLAG
, T.PUBLISH_FLAG
, T.WORKFLOW_PROCESS_ID
, T.PLANNED_END_DATE
, T.ATTRIBUTE1
, T.ATTRIBUTE2
, T.ATTRIBUTE3
, T.ATTRIBUTE4
, T.ATTRIBUTE5
, T.ATTRIBUTE6
, T.ATTRIBUTE7
, T.ATTRIBUTE8
, T.ATTRIBUTE9
, T.ATTRIBUTE10
, T.ATTRIBUTE11
, T.ATTRIBUTE12
, T.ATTRIBUTE13
, T.ATTRIBUTE14
, T.ATTRIBUTE15
, T.ATTRIBUTE_CATEGORY
FROM JTF_TASKS_VL T
, HZ_PARTIES P
, HZ_LOCATIONS L
, HZ_CUST_ACCOUNTS A
, JTF_EC_STATUSES_VL S
, HZ_PARTY_SITES PS
, (SELECT MEANING
, LOOKUP_CODE
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE ='JTF_TASK_REASON_CODES'
AND ENABLED_FLAG='Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE)) R
, (SELECT MEANING
, LOOKUP_CODE
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE ='JTF_TASK_ESC_LEVEL'
AND ENABLED_FLAG='Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE)) L
, JTF_OBJECTS_TL JTOT
WHERE T.TASK_TYPE_ID=22
AND NVL(T.DELETED_FLAG
, 'N') = 'N'
AND T.CUSTOMER_ID=P.PARTY_ID(+)
AND T.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID(+)
AND T.ADDRESS_ID = PS.PARTY_SITE_ID(+)
AND T.ESCALATION_LEVEL = L.LOOKUP_CODE(+)
AND T.REASON_CODE = R.LOOKUP_CODE(+)
AND PS.LOCATION_ID = L.LOCATION_ID(+)
AND T.TASK_STATUS_ID=S.TASK_STATUS_ID(+)
AND T.OWNER_TYPE_CODE = JTOT.OBJECT_CODE(+)
AND JTOT.LANGUAGE = USERENV('LANG')