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_PARTIES

Line 1002: hz_parties hp,

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'
1006: AND wl.source_location_id = hps.location_id

Line 1285: FROM hz_parties hz,

1281: IS
1282:
1283: CURSOR c_get_supplier(c_location_id IN NUMBER) IS
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

Line 1295: and rel.object_table_name = 'HZ_PARTIES'

1291: AND wl.location_source_code = 'HZ'
1292: AND wl.source_location_id = hps.location_id
1293: AND rel.relationship_type = 'POS_VENDOR_PARTY'
1294: and rel.object_id = hz.party_id
1295: and rel.object_table_name = 'HZ_PARTIES'
1296: and rel.object_type = 'ORGANIZATION'
1297: and rel.subject_table_name = 'PO_VENDORS'
1298: and rel.subject_id = po.vendor_id
1299: and rel.subject_type = 'POS_VENDOR'