APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_REPLENISHMENT_DETAILS

Line 10759: wms_replenishment_details WRD,

10755: wrd.repl_level, -- TO DECIDE WHETHER TO PICK_RELEASE DEMAND OR allocate repl MO FOR LEVEL > 1
10756: wdd.batch_id,
10757: wrd.demand_type_id
10758: FROM
10759: wms_replenishment_details WRD,
10760: MTL_TXN_REQUEST_LINES MTRL,
10761: WSH_DELIVERY_DETAILS WDD
10762: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
10763: AND WRD.SOURCE_LINE_ID = p_mo_line_id

Line 10780: wms_replenishment_details WRD,

10776: WRD.primary_quantity WRD_PRI_QUANTITY,
10777: wrd.repl_level, -- TO DECIDE WHETHER TO PICK_RELEASE DEMAND OR allocate repl MO FOR LEVEL > 1
10778: wrd.demand_type_id
10779: FROM
10780: wms_replenishment_details WRD,
10781: MTL_TXN_REQUEST_LINES MTRL
10782: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
10783: AND WRD.SOURCE_LINE_ID = p_mo_line_id
10784: AND wrd.demand_type_id = 4 -- true for multi level repl (>1)

Line 11001: from WMS_REPLENISHMENT_DETAILS wrd

10997: AND wdd.released_status in ('R','B') and replenishment_status is NULL
10998: AND wdd.subinventory IS NULL -- since push_repl conc program does not consider forward pick sub either
10999: -- these demands should not be part of WRD
11000: AND NOT EXISTS (select wrd.demand_line_detail_id
11001: from WMS_REPLENISHMENT_DETAILS wrd
11002: where wrd.demand_line_detail_id = wdd.delivery_detail_id
11003: and wrd.demand_line_id = wdd.source_line_id
11004: and wrd.organization_id = wdd.organization_id)
11005: ORDER BY organization_id, sort_attribute1, sort_attribute2, sort_attribute3, sort_attribute4, sort_attribute5;

Line 11732: FROM wms_replenishment_details wrd

11728: L_DROP_LPN_ITEM_TBL(CNT).move_order_line_id THEN
11729:
11730: BEGIN
11731: SELECT 1, demand_type_id INTO l_exists_in_wrd, l_demand_type_id
11732: FROM wms_replenishment_details wrd
11733: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
11734: AND WRD.SOURCE_LINE_ID = L_DROP_LPN_ITEM_TBL(CNT).MOVE_ORDER_LINE_ID
11735: AND WRD.INVENTORY_ITEM_ID = L_DROP_LPN_ITEM_TBL(CNT).INVENTORY_ITEM_ID
11736: AND ROWNUM = 1;

Line 11801: DELETE FROM WMS_REPLENISHMENT_DETAILS

11797:
11798: ELSE -- Move order got allocated successfully
11799: -- remove the record from the WRD table
11800:
11801: DELETE FROM WMS_REPLENISHMENT_DETAILS
11802: WHERE organization_id = p_org_id
11803: AND demand_type_id = 4
11804: AND demand_header_id = l_demand_header_id
11805: AND demand_line_id = l_demand_line_id;

Line 11871: DELETE FROM WMS_REPLENISHMENT_DETAILS

11867: END IF;
11868:
11869:
11870: --Remove the entry from the WRD table
11871: DELETE FROM WMS_REPLENISHMENT_DETAILS
11872: WHERE organization_id = p_org_id
11873: AND DEMAND_LINE_DETAIL_ID= l_delivery_detail_id;
11874:
11875: -- Decrease the current MMTT qty

Line 11956: DELETE FROM WMS_REPLENISHMENT_DETAILS

11952:
11953:
11954: -- delete the original demand as it was marked RC
11955: -- nwely created delviery will be in WRD as 'RR'
11956: DELETE FROM WMS_REPLENISHMENT_DETAILS
11957: WHERE DEMAND_LINE_DETAIL_ID= l_delivery_detail_id;
11958:
11959: L_REMAINING_MMTT_QTY := 0;
11960: