APPS.INV_MGD_POSITIONS_PROC dependencies on MTL_MGD_INVENTORY_POSITIONS

Line 70: FROM mtl_mgd_inventory_positions

66: END IF;
67:
68: SELECT COUNT(*)
69: INTO l_count
70: FROM mtl_mgd_inventory_positions
71: WHERE data_set_name = p_data_set_name;
72:
73: IF G_DEBUG = 'Y' THEN
74: INV_MGD_POS_UTIL.Log

Line 185: LOCK TABLE mtl_mgd_inventory_positions IN SHARE ROW EXCLUSIVE MODE;

181: , p_msg => '> '||G_PKG_NAME||'.'||'Reserve_Data_Set_Name'
182: );
183: END IF;
184:
185: LOCK TABLE mtl_mgd_inventory_positions IN SHARE ROW EXCLUSIVE MODE;
186:
187: IF Data_Set_Exists(p_data_set_name) THEN
188:
189: ROLLBACK;

Line 251: DELETE FROM mtl_mgd_inventory_positions

247: , p_msg => '> '||G_PKG_NAME||'.'||'Release_Data_Set_Name'
248: );
249: END IF;
250:
251: DELETE FROM mtl_mgd_inventory_positions
252: WHERE data_set_name = p_data_set_name
253: AND organization_id = -1
254: AND bucket_name = 'LOCK'
255: AND inventory_item_id = -1;

Line 498: -- MTL_MGD_INVENTORY_POSITIONS with data for the current

494: -- p_bucket_rec bucket
495: -- p_begin_qty begin quantity
496: -- x_end_qty end quantity
497: -- COMMENT : processes a bucket for an item by populating an entry in
498: -- MTL_MGD_INVENTORY_POSITIONS with data for the current
499: -- organization; passes the end quantity OUT NOCOPY /* file.sql.39 change */ as begin quantity
500: -- for the next bucket
501: --========================================================================
502: PROCEDURE Process_Bucket

Line 693: FROM mtl_mgd_inventory_positions

689: IS
690: SELECT
691: org_delta_qty
692: , org_end_on_hand_qty
693: FROM mtl_mgd_inventory_positions
694: WHERE data_set_name = p_data_set_name
695: AND organization_id = p_organization_id
696: AND bucket_name = p_bucket_name
697: AND inventory_item_id = p_inventory_item_id;

Line 708: FROM mtl_mgd_inventory_positions

704: IS
705: SELECT
706: hierarchy_delta_qty
707: , hierarchy_end_on_hand_qty
708: FROM mtl_mgd_inventory_positions
709: WHERE data_set_name = p_data_set_name
710: AND organization_id = p_organization_id
711: AND bucket_name = p_bucket_name
712: AND inventory_item_id = p_inventory_item_id;