VIEW: APPS.JTF_TASK_TERRITORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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