DBA Data[Home] [Help]

APPS.GR_MIGRATE_TO_12 dependencies on SY_UOMS_TYP

Line 1240: l_uom_type sy_uoms_typ.um_type%TYPE;

1236: l_migration_count NUMBER := 0;
1237: l_failure_count NUMBER := 0;
1238: l_exists_count NUMBER := 0;
1239: l_item_code VARCHAR2(32);
1240: l_uom_type sy_uoms_typ.um_type%TYPE;
1241: l_uom VARCHAR2(4);
1242: l_owner_org sy_orgn_mst.orgn_code%TYPE;
1243: l_owner_org_id sy_orgn_mst.organization_id%TYPE;
1244: l_inventory_item_id NUMBER;

Line 1284: FROM sy_uoms_typ

1280:
1281: /* Cursor used to retrieve the std uom for FM_YIELD_TYPE class */
1282: CURSOR c_get_uom (v_um_type VARCHAR2) IS
1283: SELECT std_um
1284: FROM sy_uoms_typ
1285: WHERE um_type = v_um_type;
1286:
1287: /* Cursor used to retrieve concentration records for item */
1288: CURSOR c_get_item_concentrations IS