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_TENDER_WF dependencies on HZ_CONTACT_POINTS

Line 446: FROM hz_contact_points cont, hz_relationships rel,

442: /* Bug 5312853: Query does not join contacts to sites
443: CURSOR get_notif_type_c (l_trip_id NUMBER) IS
444: SELECT car_sites.tender_transmission_method notif_type,
445: car_sites.auto_accept_load_tender auto_accept_flag,car_sites.carrier_site_id
446: FROM hz_contact_points cont, hz_relationships rel,
447: hz_party_sites sites, wsh_Carrier_sites car_sites, wsh_trips trips
448: WHERE owner_table_name = 'HZ_PARTIES'
449: and rel.party_id = owner_table_id
450: and sites.party_id =rel.subject_id

Line 460: hz_org_contacts cont, hz_contact_points points,

456: CURSOR get_notif_type_c (l_trip_id NUMBER) IS
457: SELECT car_sites.tender_transmission_method notif_type,
458: car_sites.auto_accept_load_tender auto_accept_flag,car_sites.carrier_site_id
459: FROM hz_parties party, hz_relationships rel, hz_party_sites sites,
460: hz_org_contacts cont, hz_contact_points points,
461: wsh_carrier_sites car_sites, wsh_trips trips
462: WHERE rel.object_id = party.party_id
463: AND rel.subject_type = 'ORGANIZATION'
464: AND rel.subject_Table_name = 'HZ_PARTIES'