Product: | JTF - CRM Foundation |
---|---|
Description: | Internal View for Escalations |
Implementation/DBA Data: | APPS.JTF_ESCALATION_TASK_V |
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')