APPS.GR_MIGRATE_TO_12 dependencies on MTL_SYSTEM_ITEMS_B

Line 10: -- has been migrated to the mtl_system_items_b table.

6: -- get_inventory_item_id
7: --
8: -- DESCRIPTION:
9: -- This PL/SQL procedure is used to retrieve an inventory_item_id after the item
10: -- has been migrated to the mtl_system_items_b table.
11: --
12: -- PARAMETERS:
13: -- p_organization_id - Organization id to use to retrieve the value
14: -- p_item_code - Item_code to use to retrieve the value

Line 19: -- inventory_item_id - ID of item in mtl_system_items_b table

15: -- x_return_status - Returns the status of the function (success, failure, etc.)
16: -- x_msg_data - Returns message data if an error occurred
17: --
18: -- RETURNS:
19: -- inventory_item_id - ID of item in mtl_system_items_b table
20: --
21: -- SYNOPSIS:
22: -- l_item_id := get_inventory_item_id(
23: -- p_organization_id => l_org_id,

Line 580: FROM mtl_system_items_b

576:
577: /* Cursor used to check if item for organization is already in the table */
578: CURSOR c_check_exists IS
579: SELECT inventory_item_id
580: FROM mtl_system_items_b
581: WHERE segment1 = l_mig_rec.item_code and
582: organization_id = l_mig_rec.organization_id;
583:
584: /* Cursor used to retrieve regulatory item record */

Line 776: UPDATE mtl_system_items_b

772: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
773: RAISE PROC_CALL_ERROR;
774: END IF;
775:
776: UPDATE mtl_system_items_b
777: SET hazardous_material_flag = 'Y',
778: cas_number = l_reg_item_rec.primary_cas_number,
779: hazard_class_id = l_hazard_class_id,
780: un_number_id = l_un_number_id

Line 1316: FROM mtl_system_items_b

1312:
1313: /* Cursor used to retrieve items primary_uom */
1314: CURSOR c_get_primary_uom (v_organization_id NUMBER, v_inventory_item_id NUMBER) IS
1315: SELECT primary_uom_code
1316: FROM mtl_system_items_b
1317: WHERE organization_id = v_organization_id and
1318: inventory_item_id = v_inventory_item_id;
1319:
1320: /* Cursor used to retrieve next formula_id value */