APPS.FTE_TENDER_WF dependencies on WSH_CARRIER_SITES

Line 447: hz_party_sites sites, wsh_Carrier_sites car_sites, wsh_trips trips

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

Line 461: wsh_carrier_sites car_sites, wsh_trips trips

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'
465: AND sites.party_id = rel.subject_id

Line 3333: FROM WSH_CARRIER_SITES

3329: WHERE TRIP_ID = l_trip_id;
3330:
3331: SELECT decode(ENABLE_AUTO_TENDER,null,'N','N','N','Y') AUTO_TENDER
3332: INTO l_autoTender
3333: FROM WSH_CARRIER_SITES
3334: WHERE CARRIER_ID = l_carrier_id
3335: AND ROWNUM = 1;
3336:
3337: IF (l_autoTender = 'N') THEN