VIEW: APPS.CS_SR_TASK_TERRITORY_V

Source

View Text - Preformatted

SELECT TASK.TASK_ID, CSI.INCIDENT_ID, PARTY.PARTY_ID, LOC.COUNTRY, PARTY_SITE.PARTY_SITE_ID, LOC.CITY, LOC.POSTAL_CODE, LOC.STATE, CONT_POINT.PHONE_AREA_CODE, LOC.COUNTY, PARTY.PARTY_NAME, LOC.PROVINCE, PROFILE.EMPLOYEES_TOTAL, TASK.TASK_TYPE_ID, TASK.TASK_STATUS_ID, TASK.TASK_PRIORITY_ID, CSI.INCIDENT_TYPE_ID, CSI.INCIDENT_SEVERITY_ID, CSI.INCIDENT_URGENCY_ID, CSI.PROBLEM_CODE, CSI.INCIDENT_STATUS_ID, CSI.PLATFORM_ID, CSI.SITE_ID, CSI.CUSTOMER_SITE_ID, CSITL.SR_CREATION_CHANNEL, CSI.INVENTORY_ITEM_ID, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS HZACCT, HZ_PARTY_SITES PARTY_SITE, HZ_LOCATIONS LOC, HZ_CONTACT_POINTS CONT_POINT, HZ_ORGANIZATION_PROFILES PROFILE, JTF_TASKS_VL TASK, CS_INCIDENTS_ALL_B CSI, CS_INCIDENTS_ALL_TL CSITL WHERE CSI.INCIDENT_ID = TASK.SOURCE_OBJECT_ID AND TASK.SOURCE_OBJECT_TYPE_CODE = 'SR' AND TASK.CUSTOMER_ID = PARTY.PARTY_ID AND TASK.CUSTOMER_ID = HZACCT.PARTY_ID (+) AND TASK.CUST_ACCOUNT_ID = HZACCT.CUST_ACCOUNT_ID (+) AND TASK.ADDRESS_ID = PARTY_SITE.PARTY_SITE_ID AND PARTY.PARTY_ID = PARTY_SITE.PARTY_ID AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID AND ((PARTY.PARTY_TYPE = 'PERSON') OR (PARTY.PARTY_TYPE = 'ORGANIZATION')) AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID AND PROFILE.PARTY_ID = PARTY.PARTY_ID AND CSI.INCIDENT_ID = CSITL.INCIDENT_ID AND CSITL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT TASK.TASK_ID
, CSI.INCIDENT_ID
, PARTY.PARTY_ID
, LOC.COUNTRY
, PARTY_SITE.PARTY_SITE_ID
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, CONT_POINT.PHONE_AREA_CODE
, LOC.COUNTY
, PARTY.PARTY_NAME
, LOC.PROVINCE
, PROFILE.EMPLOYEES_TOTAL
, TASK.TASK_TYPE_ID
, TASK.TASK_STATUS_ID
, TASK.TASK_PRIORITY_ID
, CSI.INCIDENT_TYPE_ID
, CSI.INCIDENT_SEVERITY_ID
, CSI.INCIDENT_URGENCY_ID
, CSI.PROBLEM_CODE
, CSI.INCIDENT_STATUS_ID
, CSI.PLATFORM_ID
, CSI.SITE_ID
, CSI.CUSTOMER_SITE_ID
, CSITL.SR_CREATION_CHANNEL
, CSI.INVENTORY_ITEM_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS HZACCT
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CONTACT_POINTS CONT_POINT
, HZ_ORGANIZATION_PROFILES PROFILE
, JTF_TASKS_VL TASK
, CS_INCIDENTS_ALL_B CSI
, CS_INCIDENTS_ALL_TL CSITL
WHERE CSI.INCIDENT_ID = TASK.SOURCE_OBJECT_ID
AND TASK.SOURCE_OBJECT_TYPE_CODE = 'SR'
AND TASK.CUSTOMER_ID = PARTY.PARTY_ID
AND TASK.CUSTOMER_ID = HZACCT.PARTY_ID (+)
AND TASK.CUST_ACCOUNT_ID = HZACCT.CUST_ACCOUNT_ID (+)
AND TASK.ADDRESS_ID = PARTY_SITE.PARTY_SITE_ID
AND PARTY.PARTY_ID = PARTY_SITE.PARTY_ID
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
AND ((PARTY.PARTY_TYPE = 'PERSON') OR (PARTY.PARTY_TYPE = 'ORGANIZATION'))
AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID
AND PROFILE.PARTY_ID = PARTY.PARTY_ID
AND CSI.INCIDENT_ID = CSITL.INCIDENT_ID
AND CSITL.LANGUAGE = USERENV('LANG')