APPS.WMS_REPLENISHMENT_PVT dependencies on WSH_DELIVERY_DETAILS

Line 464: FROM wsh_delivery_details wdd

460: l_msg_data VARCHAR2(1000);
461:
462: CURSOR c_rr_marked_wdd IS
463: SELECT delivery_detail_id
464: FROM wsh_delivery_details wdd
465: WHERE wdd.source_code = 'OE'
466: AND wdd.organization_id = p_org_id
467: AND wdd.requested_quantity > 0
468: -- excluding Replenishment Requested status

Line 982: FROM wsh_delivery_details wdd

978: and wrdg.repl_level = nvl(p_repl_level, 1);
979:
980: -- Get Q3
981: SELECT Nvl(SUM(wdd.requested_quantity),0) INTO l_other_wdd_qty
982: FROM wsh_delivery_details wdd
983: WHERE wdd.organization_id = l_org_id
984: AND wdd.inventory_item_id = l_item_id
985: AND((wdd.released_status NOT IN ('R','N','B','X','C') AND wdd.replenishment_status IS NULL)
986: OR (wdd.released_status = 'B' AND wdd.replenishment_status IS NOT NULL))

Line 2106: wsh_delivery_details wdd,

2102: L_TRIP_STOP_DATE_SORT),
2103: NULL))) as sort_attribute5
2104:
2105: FROM oe_order_lines_all oel,
2106: wsh_delivery_details wdd,
2107: MTL_ABC_ASSIGNMENTS MAA
2108: WHERE wdd.organization_id = p_organization_id
2109: AND wdd.source_code = 'OE'
2110: AND oel.booked_flag = 'Y'

Line 4457: FROM WMS_REPLENISHMENT_DETAILS wrd, wsh_delivery_details wdd

4453: (
4454: SELECT WRD.Source_line_id, WRD.source_header_id,
4455: wrd.inventory_item_id, SUM(wrd.Primary_quantity) quantity,
4456: wrd.organization_id,wrd.primary_uom
4457: FROM WMS_REPLENISHMENT_DETAILS wrd, wsh_delivery_details wdd
4458: WHERE wrd.demand_line_detail_id = wdd.delivery_detail_id
4459: AND wrd.demand_line_id = wdd.source_line_id
4460: AND wrd.organization_id = P_ORG_ID
4461: AND wrd.organization_id = wdd.organization_id

Line 5808: FROM wsh_delivery_details wdd, oe_order_lines_all ool,

5804: CURSOR wdd_rec_cursor IS
5805: SELECT NVL(wts.planned_departure_date,
5806: NVL(wdd.date_scheduled,
5807: NVL(ool.schedule_ship_date, ool.promise_date))) AS expected_ship_date
5808: FROM wsh_delivery_details wdd, oe_order_lines_all ool,
5809: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
5810: wsh_trip_stops wts, wsh_trips wt
5811: WHERE wdd.delivery_detail_id = p_delivery_line_id
5812: AND ool.line_id = p_source_line_id

Line 5880: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,

5876: SELECT MIN(NVL(wts.planned_departure_date, wdd.date_scheduled))
5877: -- MIN(NVL(wts.planned_departure_date,
5878: -- NVL(wdd.date_scheduled,
5879: -- NVL(ool.schedule_ship_date, ool.promise_date)))) AS min_expected_ship_date,
5880: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
5881: wsh_delivery_legs wdl, wsh_trip_stops wts
5882: -- oe_order_lines_all ool
5883:
5884: WHERE wdd.delivery_detail_id = p_delivery_detail_id

Line 6443: FROM wsh_delivery_details wdd

6439: 'TRIP_STOP_DATE',
6440: GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,
6441: L_TRIP_STOP_DATE_SORT),
6442: NULL))) as sort_attribute5
6443: FROM wsh_delivery_details wdd
6444: WHERE wdd.source_code = 'OE'
6445: AND wdd.organization_id = p_org_id
6446: AND wdd.requested_quantity > 0
6447: -- excluding Replenishment Requested status