APPS.CSP_PARTS_REQUIREMENT dependencies on HZ_CUST_ACCT_SITES

Line 184: hz_cust_acct_sites cas,

180: CURSOR rs_loc_cur(p_resource_type VARCHAR2, p_resource_id NUMBER) IS
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

Line 203: hz_cust_acct_sites cas,

199: CURSOR task_asgnmt_loc_cur(p_task_Assignment_id NUMBER) IS
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,

Line 356: from hz_cust_acct_sites cas,

352: ELSE
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

Line 2764: hz_cust_acct_sites_All hz,

2760:
2761: CURSOR get_resource_location IS
2762: SELECT csp.ship_to_location_id
2763: FROM csp_rs_ship_to_addresses_all_v csp,
2764: hz_cust_acct_sites_All hz,
2765: cs_incidents_all_b cs,
2766: jtf_tasks_b jtb,
2767: jtf_task_assignments jta
2768: WHERE csp.cust_acct_site_id = hz.cust_acct_site_id

Line 4185: hz_cust_acct_sites_all hcas,

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
4189: AND jtb.task_id = jta.task_id

Line 4215: hz_cust_acct_sites_all hcas,

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
4219: AND jtb.task_id = jta.task_id

Line 4236: hz_cust_acct_sites_All hz,

4232:
4233: CURSOR get_resource_location IS
4234: SELECT csp.ship_to_location_id
4235: FROM csp_rs_ship_to_addresses_all_v csp,
4236: hz_cust_acct_sites_All hz,
4237: cs_incidents_all_b cs,
4238: jtf_tasks_b jtb,
4239: jtf_task_assignments jta
4240: WHERE csp.cust_acct_site_id = hz.cust_acct_site_id