APPS.BOMPVALR dependencies on MTL_UNITS_OF_MEASURE

Line 1159: hr_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

1155: res_cnt NUMBER := 0;
1156: dummy NUMBER;
1157: hr_uom_code VARCHAR2(30);
1158: hr_uom VARCHAR2(3);
1159: hr_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
1160: commit_cnt NUMBER;
1161: continue_loop BOOLEAN := TRUE;
1162: total_recs NUMBER;
1163:

Line 1390: from mtl_units_of_measure

1386: hr_uom := ltrim(rtrim(hr_uom_code));
1387:
1388: select uom_class
1389: into hr_uom_class
1390: from mtl_units_of_measure
1391: where uom_code = hr_uom;
1392:
1393: /* get currency code */
1394: select SUBSTRB(CURRENCY_CODE, 1, 3)

Line 1404: mtl_units_of_measure uom

1400:
1401: select count(*)
1402: into res_cnt
1403: from bom_op_resources_interface ori, bom_resources br,
1404: mtl_units_of_measure uom
1405: where ori.operation_sequence_id = c1rec.OSI
1406: and ori.schedule_flag = 1
1407: and ori.resource_id = br.resource_id
1408: and uom.uom_code = br.unit_of_measure

Line 1520: from mtl_units_of_measure mum,

1516: and (autocharge_type in (3,4)
1517: or
1518: (hr_uom_class in
1519: (select uom_class
1520: from mtl_units_of_measure mum,
1521: bom_resources br
1522: where br.resource_id = bori.resource_id
1523: and mum.uom_code = br.unit_of_measure))
1524: );