APPS.CSP_EXCESS_PARTS_PVT dependencies on HZ_LOCATIONS

Line 2403: HZ_LOCATIONS HLOC,

2399: HLOC.PROVINCE,
2400: HLOC.COUNTY,
2401: HLOC.COUNTRY
2402: FROM csp_sec_inventories CINV,
2403: HZ_LOCATIONS HLOC,
2404: csp_rs_cust_relations rcr,
2405: hz_cust_acct_sites_All cas,
2406: hz_cust_site_uses_all csu,
2407: hz_party_sites ps

Line 2435: hz_locations h

2431: h.county,
2432: h.country
2433: from
2434: csp_planning_parameters c,
2435: hz_locations h
2436: where c.organization_id = v_org_id
2437: and nvl(c.secondary_inventory, 'NULL') = nvl(v_subinv, 'NULL')
2438: and c.hz_location_id = h.location_id;
2439:

Line 2737: from hz_locations hl

2733: order by tmt.absolute_rank desc;
2734:
2735: cursor c_address is
2736: select hl.city,hl.postal_code,hl.state,hl.province,hl.county,hl.country
2737: from hz_locations hl
2738: where hl.location_id = p_hz_location_id;
2739:
2740: cursor c_destination(p_return_rule_id number) is
2741: select crrr.dest_org_id,