VIEW: APPS.JTF_EC_ESC_CONTACTS_REF_DOCS

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)