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.FTE_COMP_CONSTRAINT_UTIL dependencies on HZ_RELATIONSHIPS

Line 63: hz_relationships rel

59: CURSOR c_get_sup_name(c_object_value_num IN NUMBER) IS
60: select hp.party_name
61: from hz_parties hp,
62: po_vendors po,
63: hz_relationships rel
64: where hp.party_id = c_object_value_num
65: AND rel.relationship_type = 'POS_VENDOR_PARTY'
66: and rel.object_id = hp.party_id
67: and rel.object_table_name = 'HZ_PARTIES'

Line 135: hz_relationships rel,

131: nvl(nvl(flp.facility_code,wl.location_code),to_char(wl.wsh_location_id)) facility_code,
132: nvl(flp.description,wl.ui_location_code) description
133: FROM hz_parties hp ,
134: po_vendors po,
135: hz_relationships rel,
136: hz_party_sites hps,
137: wsh_locations wl,
138: fte_location_parameters flp
139: WHERE hps.party_id = hp.party_id

Line 460: hz_relationships rel,

456: hp.party_name||'/'||nvl(hps.party_site_name,hps.party_site_number)
457: site, 'SUPPLIER' company_type
458: FROM hz_parties hp ,
459: po_vendors po,
460: hz_relationships rel,
461: hz_party_sites hps,
462: wsh_locations wl
463: where wl.source_location_id=hps.location_id
464: and hps.party_id=hp.party_id