Product: | JTF - CRM Foundation |
---|---|
Description: | Internal View for Escalation Reference Documents |
Implementation/DBA Data: | APPS.JTF_EC_ESC_CONTACTS_REF_DOCS |
SELECT T.TASK_ID
, T.TASK_NUMBER
, T.CUSTOMER_ID
, T.PARTY_NAME
, T.CUST_ACCOUNT_ID
, T.ADDRESS_ID
, T.CITY
, T.TASK_STATUS_ID
, T.OWNER_ID
, T.ACTUAL_START_DATE
, T.OWNER_TERRITORY_ID
, T.DESCRIPTION
, T.REASON_CODE
, C.CONTACT_TYPE_CODE
, C.CONTACT_ID
, R.OBJECT_TYPE_CODE
, R.OBJECT_ID
, R.OBJECT_NAME
FROM JTF_ESCALATION_TASK_V T
, JTF_TASK_CONTACTS C
, JTF_TASK_REFERENCES_VL R
WHERE T.TASK_ID=C.TASK_ID(+)
AND T.TASK_ID=R.TASK_ID(+)