APPS.INV_MIGRATE_PROCESS_ORG dependencies on MTL_SECONDARY_INVENTORIES

Line 41: FROM mtl_secondary_inventories

37: CURSOR Cur_check_subinventory IS
38: SELECT 1
39: FROM dual
40: WHERE EXISTS (SELECT 1
41: FROM mtl_secondary_inventories
42: WHERE secondary_inventory_name = P_whse_code
43: AND organization_id = P_organization_id);
44:
45: CURSOR Cur_get_details(V_organization_id NUMBER) IS

Line 87: --Now insert the warehouse into mtl_secondary_inventories table

83: ELSE
84: l_locator_type := 1;
85: END IF;
86:
87: --Now insert the warehouse into mtl_secondary_inventories table
88: mtl_secondary_inventories_pkg.insert_row (
89: x_rowid => l_rowid
90: , x_secondary_inventory_name => P_whse_code
91: , x_organization_id => P_organization_id

Line 88: mtl_secondary_inventories_pkg.insert_row (

84: l_locator_type := 1;
85: END IF;
86:
87: --Now insert the warehouse into mtl_secondary_inventories table
88: mtl_secondary_inventories_pkg.insert_row (
89: x_rowid => l_rowid
90: , x_secondary_inventory_name => P_whse_code
91: , x_organization_id => P_organization_id
92: , x_last_update_date => SYSDATE

Line 300: UPDATE mtl_secondary_inventories

296: END IF;
297: CLOSE Cur_get_oper_unit;
298:
299: /* Update the locator control for the existing subinventories to be determined at item level */
300: UPDATE mtl_secondary_inventories
301: SET locator_type = 5
302: WHERE organization_id = l_rec.organization_id
303: AND EXISTS (SELECT 1
304: FROM IC_WHSE_MST

Line 310: UPDATE mtl_secondary_inventories

306: AND mtl_organization_id = l_rec.organization_id);
307:
308: /* Update secondary inventories table for any rows that had the default cost group id */
309: /* missing - due to an issue in the gmf_mtl_parameters_biur_tg trigger code - Bug 5553034*/
310: UPDATE mtl_secondary_inventories
311: SET default_cost_group_id = (SELECT default_cost_group_id
312: FROM mtl_parameters
313: WHERE organization_id = l_rec.organization_id)
314: WHERE default_cost_group_id IS NULL

Line 792: FROM mtl_secondary_inventories

788: CURSOR Cur_check_subinventory(V_whse_code VARCHAR2, V_organization_id NUMBER) IS
789: SELECT 1
790: FROM dual
791: WHERE EXISTS (SELECT 1
792: FROM mtl_secondary_inventories
793: WHERE secondary_inventory_name = V_whse_code
794: AND organization_id = V_organization_id);
795:
796: CURSOR Cur_get_details(V_orgn_id NUMBER) IS

Line 866: UPDATE mtl_secondary_inventories

862:
863: OPEN Cur_check_subinventory(l_rec.whse_code, l_organization_id);
864: FETCH Cur_check_subinventory INTO l_temp;
865: IF (Cur_check_subinventory%FOUND) THEN
866: UPDATE mtl_secondary_inventories
867: SET locator_type = l_locator_type,
868: default_loc_status_id = 1
869: WHERE organization_id = l_organization_id
870: AND secondary_inventory_name = l_rec.whse_code;

Line 886: --Now insert the warehouse into mtl_secondary_inventories table

882: UPDATE ic_loct_mst
883: SET locator_id = inventory_location_id
884: WHERE whse_code = l_rec.whse_code;
885: ELSE
886: --Now insert the warehouse into mtl_secondary_inventories table
887: mtl_secondary_inventories_pkg.insert_row (
888: x_rowid => l_rowid
889: , x_secondary_inventory_name => l_rec.whse_code
890: , x_organization_id => l_organization_id

Line 887: mtl_secondary_inventories_pkg.insert_row (

883: SET locator_id = inventory_location_id
884: WHERE whse_code = l_rec.whse_code;
885: ELSE
886: --Now insert the warehouse into mtl_secondary_inventories table
887: mtl_secondary_inventories_pkg.insert_row (
888: x_rowid => l_rowid
889: , x_secondary_inventory_name => l_rec.whse_code
890: , x_organization_id => l_organization_id
891: , x_last_update_date => SYSDATE

Line 1425: mtl_secondary_inventories_pkg.insert_row (

1421: l_cost_group_id, l_parameter.wms_enabled_flag, l_parameter.qa_skipping_insp_flag,p_default_status_id);
1422:
1423:
1424: /* Bug 5620938 - A default subinventory must be created for the organization */
1425: mtl_secondary_inventories_pkg.insert_row (
1426: x_rowid => l_rowid
1427: , x_secondary_inventory_name => l_orgn_code
1428: , x_organization_id => X_organization_id
1429: , x_last_update_date => SYSDATE