DBA Data[Home] [Help]

APPS.GR_MIGRATE_TO_12 dependencies on SY_UOMS_TYP

Line 1264: l_uom_type sy_uoms_typ.um_type%TYPE;

1260: l_migration_count NUMBER := 0;
1261: l_failure_count NUMBER := 0;
1262: l_exists_count NUMBER := 0;
1263: l_item_code VARCHAR2(32);
1264: l_uom_type sy_uoms_typ.um_type%TYPE;
1265: l_uom VARCHAR2(4);
1266: l_owner_org sy_orgn_mst.orgn_code%TYPE;
1267: l_owner_org_id sy_orgn_mst.organization_id%TYPE;
1268: l_inventory_item_id NUMBER;

Line 1308: FROM sy_uoms_typ

1304:
1305: /* Cursor used to retrieve the std uom for FM_YIELD_TYPE class */
1306: CURSOR c_get_uom (v_um_type VARCHAR2) IS
1307: SELECT std_um
1308: FROM sy_uoms_typ
1309: WHERE um_type = v_um_type;
1310:
1311: /* Cursor used to retrieve concentration records for item */
1312: CURSOR c_get_item_concentrations IS