APPS.FTE_MLS_UTIL dependencies on WSH_NEW_DELIVERIES

Line 1109: wsh_new_deliveries WND

1105: IS
1106: SELECT 'x'
1107: FROM wsh_trip_stops WTS,
1108: wsh_delivery_legs WDL,
1109: wsh_new_deliveries WND
1110: WHERE WTS.trip_id = p_trip_segment_rec.trip_id
1111: AND WND.delivery_id = WDL.delivery_id
1112: AND WND.status_code IN ( 'IT', 'CL' )
1113: AND (

Line 1215: wsh_new_deliveries WND

1211: CURSOR intransit_deliveries_cur
1212: IS
1213: SELECT 'x'
1214: FROM wsh_delivery_legs WDL,
1215: wsh_new_deliveries WND
1216: WHERE WND.delivery_id = WDL.delivery_id
1217: AND WND.status_code IN ( 'IT', 'CL' )
1218: AND (
1219: WDL.pick_up_stop_id = p_trip_stop_id

Line 1843: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,

1839:
1840: CURSOR get_org_info_cur (c_stop_id IN NUMBER)
1841: IS
1842: SELECT distinct(org.name) org_name
1843: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1844: wsh_trip_stops stops, hr_organization_units org
1845: WHERE dlegs.delivery_id = dlvy.delivery_id
1846: AND dlegs.pick_up_stop_id = stops.stop_id
1847: AND org.organization_id = dlvy.organization_id

Line 1883: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,

1879:
1880: CURSOR get_org_info_cur (c_trip_id IN NUMBER)
1881: IS
1882: SELECT distinct(org.name) org_name
1883: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1884: wsh_trip_stops stops, hr_organization_units org,
1885: wsh_trips trips
1886: WHERE dlegs.delivery_id = dlvy.delivery_id
1887: AND dlegs.pick_up_stop_id = stops.stop_id

Line 1925: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,

1921:
1922: CURSOR get_org_info_cur (c_trip_id IN NUMBER)
1923: IS
1924: SELECT distinct(dlvy.organization_id) org_id
1925: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1926: wsh_trip_stops stops, wsh_trips trips
1927: WHERE dlegs.delivery_id = dlvy.delivery_id
1928: AND dlegs.pick_up_stop_id = stops.stop_id
1929: AND stops.trip_id = trips.trip_id

Line 2532: WSH_CARRIERS car, wsh_new_deliveries del

2528: CURSOR GET_VENDOR_SITE_ID_FOR_DLVY IS
2529: SELECT decode(sites.supplier_site_id,null,car.supplier_site_id,
2530: sites.supplier_site_id), car.currency_code FROM WSH_ORG_CARRIER_SITES org_sites,
2531: WSH_CARRIER_SITES sites,
2532: WSH_CARRIERS car, wsh_new_deliveries del
2533: WHERE org_sites.ORGANIZATION_ID = del.organization_id
2534: AND sites.carrier_site_id = org_sites.carrier_site_id
2535: AND sites.carrier_id = car.carrier_id
2536: AND car.CARRIER_ID = del.carrier_id

Line 2635: FROM WSH_NEW_DELIVERIES

2631: l_carrier_id := p_carrier_id;
2632: --}
2633: ELSE
2634: SELECT CARRIER_ID INTO l_carrier_id
2635: FROM WSH_NEW_DELIVERIES
2636: WHERE DELIVERY_ID = p_entity_id;
2637: END IF;
2638:
2639:

Line 2640: SELECT ORGANIZATION_ID INTO l_organization_id FROM WSH_NEW_DELIVERIES

2636: WHERE DELIVERY_ID = p_entity_id;
2637: END IF;
2638:
2639:
2640: SELECT ORGANIZATION_ID INTO l_organization_id FROM WSH_NEW_DELIVERIES
2641: WHERE DELIVERY_ID = p_entity_id;
2642:
2643: --}
2644: ELSIF (UPPER(P_ENTITY_TYPE) = 'LOCATION')

Line 2866: WSH_CARRIERS car, wsh_new_deliveries del

2862: sites.supplier_site_id), car.currency_code,car.supplier_id,
2863: sites.carrier_site_id
2864: FROM WSH_ORG_CARRIER_SITES org_sites,
2865: WSH_CARRIER_SITES sites,
2866: WSH_CARRIERS car, wsh_new_deliveries del
2867: WHERE org_sites.ORGANIZATION_ID = del.organization_id
2868: AND sites.carrier_site_id = org_sites.carrier_site_id
2869: AND sites.carrier_id = car.carrier_id
2870: AND car.CARRIER_ID = del.carrier_id

Line 3114: WSH_NEW_DELIVERIES dlvy

3110:
3111: CURSOR GET_ORG_ID_BY_DELIVERY (l_stop_id NUMBER) IS
3112: SELECT dlvy.ORGANIZATION_ID
3113: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,
3114: WSH_NEW_DELIVERIES dlvy
3115: WHERE stops.stop_id = leg.pick_up_stop_id
3116: AND leg.delivery_id = dlvy.delivery_id
3117: AND stops.stop_id = l_stop_id;
3118: