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_CUST_ACCT_SITES_ALL

Line 1091: hz_cust_acct_sites_all hcasa,

1087: cursor c_hz_address is
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'

Line 2032: HZ_CUST_ACCT_SITES_ALL hcas,

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
2036: AND pol.org_id = hcas.org_id

Line 2122: hz_cust_acct_sites_all hcsa,

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,
2122: hz_cust_acct_sites_all hcsa,
2123: csp_requirement_headers crh
2124: WHERE crh.requirement_header_id = p_req_header_id
2125: AND ploc.location_id = crh.ship_to_location_id
2126: --AND ploc.customer_id = hcsa.cust_account_id