APPS.CSP_PARTS_REQUIREMENT dependencies on HZ_CUST_SITE_USES

Line 185: hz_cust_site_uses csu,

181: SELECT pla.location_id inv_loc_id,
182: hzl.time_zone
183: from csp_rs_cust_relations rcr,
184: hz_cust_acct_sites cas,
185: hz_cust_site_uses csu,
186: po_location_associations pla,
187: hz_party_sites ps,
188: hz_locations hzl
189: where rcr.customer_id = cas.cust_account_id

Line 204: hz_cust_site_uses csu,

200: SELECT pla.location_id inv_loc_id,
201: hzl.time_zone timezone_id
202: from csp_rs_cust_relations rcr,
203: hz_cust_acct_sites cas,
204: hz_cust_site_uses csu,
205: po_location_associations pla,
206: hz_party_sites ps,
207: hz_locations hzl,
208: jtf_task_assignments jta

Line 357: hz_cust_site_uses csu,

353: BEGIN
354: SELECT hzl.time_zone time_zone_id
355: INTO l_timezone_id
356: from hz_cust_acct_sites cas,
357: hz_cust_site_uses csu,
358: po_location_associations pla,
359: hz_party_sites ps,
360: hz_locations hzl
361: where cas.cust_acct_site_id = csu.cust_acct_site_id (+)

Line 4184: hz_cust_site_uses_all hcsu,

4180: cia.org_id
4181: FROM jtf_party_locations_v jpl,
4182: cs_incidents_all_b cia,
4183: jtf_tasks_b jtb,
4184: hz_cust_site_uses_all hcsu,
4185: hz_cust_acct_sites_all hcas,
4186: po_location_associations_all pa,
4187: jtf_task_assignments jta
4188: WHERE jta.task_assignment_id = l_Task_Assignment_id

Line 4214: hz_cust_site_uses_all hcsu,

4210: cia.org_id
4211: FROM jtf_party_locations_v jpl,
4212: cs_incidents_all_b cia,
4213: jtf_tasks_b jtb,
4214: hz_cust_site_uses_all hcsu,
4215: hz_cust_acct_sites_all hcas,
4216: po_location_associations_all pa,
4217: jtf_task_assignments jta
4218: WHERE jta.task_assignment_id = l_Task_Assignment_id