APPS.FTE_TL_RATING dependencies on WSH_NEW_DELIVERIES

Line 544: FROM wsh_new_deliveries wd, wsh_global_parameters wgp

540: -- count the number of deliveries which should not be rated due to freight term
541: CURSOR c_check_trip_freight_term(c_trip_id IN NUMBER)
542: IS
543: SELECT count(wd.delivery_id)
544: FROM wsh_new_deliveries wd, wsh_global_parameters wgp
545: WHERE (
546: ((wd.shipment_direction in ('I'))
547: and (wgp.rate_ib_dels_fgt_term is not null)
548: and (wd.freight_terms_code is not null)

Line 580: FROM wsh_new_deliveries a,

576: -- count the number of deliveries which should not be rated due to manifesting
577: CURSOR c_check_trip_manifesting(c_trip_id IN NUMBER)
578: IS
579: SELECT count(a.delivery_id)
580: FROM wsh_new_deliveries a,
581: mtl_parameters b,
582: wsh_carriers c
583: WHERE a.organization_id = b.organization_id
584: AND a.carrier_id = c.carrier_id

Line 602: FROM wsh_new_deliveries wd, wsh_global_parameters wgp

598: -- count the number of deliveries which should not be rated due to freight term
599: CURSOR c_check_move_freight_term(c_move_id IN NUMBER)
600: IS
601: SELECT count(wd.delivery_id)
602: FROM wsh_new_deliveries wd, wsh_global_parameters wgp
603: WHERE (
604: ((wd.shipment_direction in ('I'))
605: and (wgp.rate_ib_dels_fgt_term is not null)
606: and (wd.freight_terms_code is not null)

Line 638: FROM wsh_new_deliveries a,

634: -- count the number of deliveries which should not be rated due to manifesting
635: CURSOR c_check_move_manifesting(c_move_id IN NUMBER)
636: IS
637: SELECT count(a.delivery_id)
638: FROM wsh_new_deliveries a,
639: mtl_parameters b,
640: wsh_carriers c
641: WHERE a.organization_id = b.organization_id
642: AND a.carrier_id = c.carrier_id