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.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on HZ_PARTY_SITES

Line 1001: hz_party_sites hps,

997:
998: CURSOR c_get_carrier(c_location_id IN NUMBER) IS
999: SELECT wc.carrier_id
1000: FROM wsh_locations wl,
1001: hz_party_sites hps,
1002: hz_parties hp,
1003: wsh_carriers wc
1004: WHERE wl.wsh_location_id = c_location_id
1005: AND wl.location_source_code = 'HZ'

Line 1089: hz_party_sites hps,

1085:
1086: CURSOR c_get_customer(c_location_id IN NUMBER) IS
1087: SELECT hcas.cust_account_id
1088: FROM wsh_locations wl,
1089: hz_party_sites hps,
1090: hz_cust_acct_sites_all hcas
1091: WHERE wl.wsh_location_id = c_location_id
1092: AND wl.location_source_code = 'HZ'
1093: AND wl.source_location_id = hps.location_id

Line 1288: hz_party_sites hps,

1284: SELECT hz.party_id
1285: FROM hz_parties hz,
1286: po_vendors po,
1287: hz_relationships rel,
1288: hz_party_sites hps,
1289: wsh_locations wl
1290: WHERE wl.wsh_location_id = c_location_id
1291: AND wl.location_source_code = 'HZ'
1292: AND wl.source_location_id = hps.location_id