APPS.WMS_REPLENISHMENT_PVT dependencies on WSH_DELIVERY_DETAILS

Line 465: FROM wsh_delivery_details wdd

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

Line 999: FROM wsh_delivery_details wdd

995: and wrdg.repl_level = nvl(p_repl_level, 1);
996:
997: -- Get Q3
998: SELECT Nvl(SUM(wdd.requested_quantity),0) INTO l_other_wdd_qty
999: FROM wsh_delivery_details wdd
1000: WHERE wdd.organization_id = l_org_id
1001: AND wdd.inventory_item_id = l_item_id
1002: AND((wdd.released_status NOT IN ('R','N','B','X','C') AND wdd.replenishment_status IS NULL)
1003: OR (wdd.released_status = 'B' AND wdd.replenishment_status IS NOT NULL))

Line 2167: wsh_delivery_details wdd

2163: L_TRIP_STOP_DATE_SORT),
2164: NULL))) as sort_attribute5
2165:
2166: FROM oe_order_lines_all oel,
2167: wsh_delivery_details wdd
2168: WHERE wdd.organization_id = p_organization_id
2169: AND wdd.source_code = 'OE'
2170: AND oel.booked_flag = 'Y'
2171: AND oel.open_flag = 'Y'

Line 4599: FROM WMS_REPLENISHMENT_DETAILS wrd, wsh_delivery_details wdd

4595: (
4596: SELECT WRD.Source_line_id, WRD.source_header_id,
4597: wrd.inventory_item_id, SUM(wrd.Primary_quantity) quantity,
4598: wrd.organization_id,wrd.primary_uom
4599: FROM WMS_REPLENISHMENT_DETAILS wrd, wsh_delivery_details wdd
4600: WHERE wrd.demand_line_detail_id = wdd.delivery_detail_id
4601: AND wrd.demand_line_id = wdd.source_line_id
4602: AND wrd.organization_id = P_ORG_ID
4603: AND wrd.organization_id = wdd.organization_id

Line 5978: FROM wsh_delivery_details wdd, oe_order_lines_all ool,

5974: CURSOR wdd_rec_cursor IS
5975: SELECT NVL(wts.planned_departure_date,
5976: NVL(wdd.date_scheduled,
5977: NVL(ool.schedule_ship_date, ool.promise_date))) AS expected_ship_date
5978: FROM wsh_delivery_details wdd, oe_order_lines_all ool,
5979: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
5980: wsh_trip_stops wts, wsh_trips wt
5981: WHERE wdd.delivery_detail_id = p_delivery_line_id
5982: AND ool.line_id = p_source_line_id

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

6046: SELECT MIN(NVL(wts.planned_departure_date, wdd.date_scheduled))
6047: -- MIN(NVL(wts.planned_departure_date,
6048: -- NVL(wdd.date_scheduled,
6049: -- NVL(ool.schedule_ship_date, ool.promise_date)))) AS min_expected_ship_date,
6050: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
6051: wsh_delivery_legs wdl, wsh_trip_stops wts
6052: -- oe_order_lines_all ool
6053:
6054: WHERE wdd.delivery_detail_id = p_delivery_detail_id

Line 6614: FROM wsh_delivery_details wdd

6610: 'TRIP_STOP_DATE',
6611: GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,
6612: L_TRIP_STOP_DATE_SORT),
6613: NULL))) as sort_attribute5
6614: FROM wsh_delivery_details wdd
6615: WHERE wdd.source_code = 'OE'
6616: AND wdd.organization_id = p_org_id
6617: AND wdd.requested_quantity > 0
6618: -- excluding Replenishment Requested status