eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PART_SEARCH_PVT dependencies on HZ_PARTY_SITES

Line 342: hz_party_sites hps,

338: from csp_planning_parameters cpp,
339: csp_dedicated_sites cds,
340: jtf_tasks_b jtb,
341: csp_requirement_headers crh,
342: hz_party_sites hps,
343: hz_locations hl
344: where cds.planning_parameters_id = cpp.planning_parameters_id
345: and nvl(cpp.stocking_site_excl,'N') = 'N'
346: and cpp.stocking_site_type = 'DEDICATED'

Line 1092: hz_party_sites hps

1088: select hps.location_id
1089: from hz_cust_site_uses_all hcsua,
1090: po_location_associations_all plaa,
1091: hz_cust_acct_sites_all hcasa,
1092: hz_party_sites hps
1093: where plaa.location_id = p_search_params.to_location_id
1094: and hcsua.site_use_id = plaa.site_use_id
1095: and hcsua.site_use_code = 'SHIP_TO'
1096: and hcsua.status = 'A'

Line 2031: hz_party_sites hps,

2027: hl.country,
2028: hl.location_id,
2029: nvl(hl.timezone_id, -9999)
2030: FROM hz_locations hl,
2031: hz_party_sites hps,
2032: HZ_CUST_ACCT_SITES_ALL hcas,
2033: PO_LOCATION_ASSOCIATIONS_ALL pol
2034: WHERE hl.location_id = hps.location_id
2035: AND hcas.party_site_id = hps.party_site_id

Line 2117: hz_party_sites hps

2113: -- now get destination ship_to address's geocode
2114: SELECT hloc.GEOMETRY
2115: INTO l_dest_geo
2116: FROM hz_locations hloc,
2117: hz_party_sites hps
2118: WHERE hloc.location_id = hps.location_id
2119: AND hps.party_site_id =
2120: ( SELECT DISTINCT party_site_id
2121: FROM po_location_associations_all ploc,