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 PO_LOCATION_ASSOCIATIONS_ALL

Line 1090: po_location_associations_all plaa,

1086:
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

Line 2033: PO_LOCATION_ASSOCIATIONS_ALL pol

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
2037: AND pol.address_id = hcas.cust_acct_site_id

Line 2121: FROM po_location_associations_all ploc,

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,
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