DBA Data[Home] [Help]

APPS.GMI_RESERVATION_UTIL dependencies on MTL_UNITS_OF_MEASURE

Line 1094: FROM mtl_units_of_measure mtl,

1090:
1091: /* For OPM MiniPack E customers */
1092: CURSOR c_uom (discrete_uom IN VARCHAR) IS
1093: SELECT sy.um_code
1094: FROM mtl_units_of_measure mtl,
1095: sy_uoms_mst sy
1096: WHERE sy.unit_of_measure = mtl.unit_of_measure
1097: AND mtl.uom_code = discrete_uom;
1098:

Line 1103: FROM mtl_units_of_measure mtl,

1099: /*
1100: Only UNCOMMENT for NON - MINI-E customers
1101: CURSOR c_uom (discrete_uom IN VARCHAR) IS
1102: SELECT sy.um_code
1103: FROM mtl_units_of_measure mtl,
1104: sy_uoms_mst sy
1105: WHERE sy.um_code = mtl.unit_of_measure
1106: AND mtl.uom_code = discrete_uom;
1107: */

Line 1170: FROM mtl_units_of_measure mtl,

1166:
1167: /* For OPM MiniPack E customers */
1168: CURSOR c_uom (process_uom IN VARCHAR) IS
1169: SELECT mtl.uom_code
1170: FROM mtl_units_of_measure mtl,
1171: sy_uoms_mst sy
1172: WHERE sy.unit_of_measure = mtl.unit_of_measure
1173: AND sy.um_code = process_uom;
1174:

Line 1179: FROM mtl_units_of_measure mtl,

1175: /*
1176: Only UNCOMMENT for NON - MINI-E customers
1177: CURSOR c_uom (process_uom IN VARCHAR) IS
1178: SELECT mtl.uom_code
1179: FROM mtl_units_of_measure mtl,
1180: sy_uoms_mst sy
1181: WHERE sy.um_code = mtl.unit_of_measure
1182: AND sy.um_code = process_uom;
1183: */