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 583: FROM mtl_system_items_b

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

Line 799: UPDATE mtl_system_items_b

795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
796: RAISE PROC_CALL_ERROR;
797: END IF;
798:
799: UPDATE mtl_system_items_b
800: SET hazardous_material_flag = 'Y',
801: cas_number = l_reg_item_rec.primary_cas_number,
802: hazard_class_id = l_hazard_class_id,
803: un_number_id = l_un_number_id

Line 1340: FROM mtl_system_items_b

1336:
1337: /* Cursor used to retrieve items primary_uom */
1338: CURSOR c_get_primary_uom (v_organization_id NUMBER, v_inventory_item_id NUMBER) IS
1339: SELECT primary_uom_code
1340: FROM mtl_system_items_b
1341: WHERE organization_id = v_organization_id and
1342: inventory_item_id = v_inventory_item_id;
1343:
1344: /* Cursor used to retrieve next formula_id value */