Product: | JTF - CRM Foundation |
---|---|
Description: | Internal View used by the Assignment Manager |
Implementation/DBA Data: | APPS.JTF_TASK_TERRITORY_V |
SELECT TASK.TASK_ID
, TASK.CUSTOMER_ID PARTY_ID
, LOC.COUNTRY
, TASK.ADDRESS_ID
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, CONT_POINT.PHONE_AREA_CODE AREA_CODE
, LOC.COUNTY
, JTF_TASK_UTL.GET_CUSTOMER_NAME(CUSTOMER_ID) COMP_NAME_RANGE
, LOC.PROVINCE
, NULL NUM_OF_EMPLOYEES
, TASK.TASK_TYPE_ID
, TASK.TASK_STATUS_ID
, TASK.TASK_PRIORITY_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CONTACT_POINTS CONT_POINT
, JTF_TASKS_VL TASK
WHERE TASK.ADDRESS_ID = PARTY_SITE.PARTY_SITE_ID (+)
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID (+)
AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CONT_POINT.OWNER_TABLE_ID(+) = TASK.CUSTOMER_ID