APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_REPLENISHMENT_DETAILS

Line 10790: wms_replenishment_details WRD,

10786: wrd.repl_level, -- TO DECIDE WHETHER TO PICK_RELEASE DEMAND OR allocate repl MO FOR LEVEL > 1
10787: wdd.batch_id,
10788: wrd.demand_type_id
10789: FROM
10790: wms_replenishment_details WRD,
10791: MTL_TXN_REQUEST_LINES MTRL,
10792: WSH_DELIVERY_DETAILS WDD
10793: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
10794: AND WRD.SOURCE_LINE_ID = p_mo_line_id

Line 10811: wms_replenishment_details WRD,

10807: WRD.primary_quantity WRD_PRI_QUANTITY,
10808: wrd.repl_level, -- TO DECIDE WHETHER TO PICK_RELEASE DEMAND OR allocate repl MO FOR LEVEL > 1
10809: wrd.demand_type_id
10810: FROM
10811: wms_replenishment_details WRD,
10812: MTL_TXN_REQUEST_LINES MTRL
10813: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
10814: AND WRD.SOURCE_LINE_ID = p_mo_line_id
10815: AND wrd.demand_type_id = 4 -- true for multi level repl (>1)

Line 11038: from WMS_REPLENISHMENT_DETAILS wrd

11034: AND wdd.released_status in ('R','B') and replenishment_status is NULL --9356579
11035: AND wdd.subinventory IS NULL -- since push_repl conc program does not consider forward pick sub either
11036: -- these demands should not be part of WRD
11037: AND NOT EXISTS (select wrd.demand_line_detail_id
11038: from WMS_REPLENISHMENT_DETAILS wrd
11039: where wrd.demand_line_detail_id = wdd.delivery_detail_id
11040: and wrd.demand_line_id = wdd.source_line_id
11041: and wrd.organization_id = wdd.organization_id)
11042: ORDER BY organization_id, sort_attribute1, sort_attribute2, sort_attribute3, sort_attribute4, sort_attribute5;

Line 11900: FROM wms_replenishment_details wrd

11896: L_DROP_LPN_ITEM_TBL(CNT).move_order_line_id THEN
11897:
11898: BEGIN
11899: SELECT 1, demand_type_id INTO l_exists_in_wrd, l_demand_type_id
11900: FROM wms_replenishment_details wrd
11901: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
11902: AND WRD.SOURCE_LINE_ID = L_DROP_LPN_ITEM_TBL(CNT).MOVE_ORDER_LINE_ID
11903: AND WRD.INVENTORY_ITEM_ID = L_DROP_LPN_ITEM_TBL(CNT).INVENTORY_ITEM_ID
11904: AND ROWNUM = 1;

Line 11969: DELETE FROM WMS_REPLENISHMENT_DETAILS

11965:
11966: ELSE -- Move order got allocated successfully
11967: -- remove the record from the WRD table
11968:
11969: DELETE FROM WMS_REPLENISHMENT_DETAILS
11970: WHERE organization_id = p_org_id
11971: AND demand_type_id = 4
11972: AND demand_header_id = l_demand_header_id
11973: AND demand_line_id = l_demand_line_id;

Line 12041: DELETE FROM WMS_REPLENISHMENT_DETAILS

12037: END IF;
12038:
12039:
12040: --Remove the entry from the WRD table
12041: DELETE FROM WMS_REPLENISHMENT_DETAILS
12042: WHERE organization_id = p_org_id
12043: AND DEMAND_LINE_DETAIL_ID= l_delivery_detail_id;
12044:
12045: -- Decrease the current MMTT qty

Line 12126: DELETE FROM WMS_REPLENISHMENT_DETAILS

12122:
12123:
12124: -- delete the original demand as it was marked RC
12125: -- nwely created delviery will be in WRD as 'RR'
12126: DELETE FROM WMS_REPLENISHMENT_DETAILS
12127: WHERE DEMAND_LINE_DETAIL_ID= l_delivery_detail_id;
12128:
12129: L_REMAINING_MMTT_QTY := 0;
12130:

Line 16052: FROM wms_replenishment_details

16048:
16049: CURSOR wrd_records_for_mo
16050: IS
16051: SELECT DEMAND_LINE_DETAIL_ID, PRIMARY_QUANTITY
16052: FROM wms_replenishment_details
16053: WHERE SOURCE_LINE_ID = p_mo_line_id
16054: AND organization_id = p_organization_id;
16055:
16056: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 16136: FROM WMS_REPLENISHMENT_DETAILS --Do only one delete based on MO line rather than multiple deletes based on WDD..

16132: mydebug('Deleting the WRDs assosciated with delivery_detail_id ' || l_demand_line_detail_id);
16133: END IF;
16134:
16135: DELETE
16136: FROM WMS_REPLENISHMENT_DETAILS --Do only one delete based on MO line rather than multiple deletes based on WDD..
16137: WHERE SOURCE_LINE_ID = p_mo_line_id;
16138:
16139: END IF;
16140: