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_PARTIES

Line 430: hz_parties hz, wsh_trips wt

426: l_carrier_name VARCHAR2(360);
427:
428: cursor get_carrier_name (c_trip_id number) is
429: select hz.party_name from
430: hz_parties hz, wsh_trips wt
431: where wt.carrier_id= hz.party_id AND
432: wt.trip_id = c_trip_id;
433:
434: CURSOR get_trip_cur(c_trip_id NUMBER) is

Line 448: WHERE owner_table_name = 'HZ_PARTIES'

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
451: and car_sites.carrier_site_id = sites.party_site_id
452: and trips.carrier_contact_id = owner_table_id

Line 459: FROM hz_parties party, hz_relationships rel, hz_party_sites sites,

455:
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'

Line 464: AND rel.subject_Table_name = 'HZ_PARTIES'

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'
465: AND sites.party_id = rel.subject_id
466: AND cont.party_site_id = sites.party_site_id
467: AND cont.party_relationship_id = rel.relationship_id
468: AND points.owner_table_id = rel.party_id

Line 469: AND points.owner_table_name = 'HZ_PARTIES'

465: AND sites.party_id = rel.subject_id
466: AND cont.party_site_id = sites.party_site_id
467: AND cont.party_relationship_id = rel.relationship_id
468: AND points.owner_table_id = rel.party_id
469: AND points.owner_table_name = 'HZ_PARTIES'
470: AND points.contact_point_type = 'EMAIL'
471: AND car_sites.carrier_site_id = sites.party_site_id
472: AND trips.carrier_contact_id = points.owner_table_id
473: AND trips.trip_id = l_trip_id;