APPS.PO_UOM_S dependencies on MTL_UNITS_OF_MEASURE

Line 35: FROM mtl_units_of_measure

31: /* Check if the given Unit of Measure is active */
32:
33: SELECT unit_of_measure
34: INTO X_unit_of_measure_v
35: FROM mtl_units_of_measure
36: WHERE sysdate < nvl(disable_date, sysdate + 1)
37: AND unit_of_measure = X_unit_of_measure;
38:
39: return (TRUE);

Line 514: from mtl_units_of_measure cuom,

510: begin
511:
512: select buom.unit_of_measure
513: into primary_unit
514: from mtl_units_of_measure cuom,
515: mtl_units_of_measure buom
516: where cuom.unit_of_measure = current_unit_of_measure
517: and cuom.uom_class = buom.uom_class
518: and buom.base_uom_flag = 'Y';

Line 515: mtl_units_of_measure buom

511:
512: select buom.unit_of_measure
513: into primary_unit
514: from mtl_units_of_measure cuom,
515: mtl_units_of_measure buom
516: where cuom.unit_of_measure = current_unit_of_measure
517: and cuom.uom_class = buom.uom_class
518: and buom.base_uom_flag = 'Y';
519:

Line 879: from mtl_system_items msi, mtl_units_of_measure muom

875: if (p_item_id is not null) then
876: begin
877: select msi.tracking_quantity_ind,msi.secondary_uom_code, muom.unit_of_measure
878: into l_tracking_quantity_ind, x_secondary_uom_code,x_secondary_unit_of_measure
879: from mtl_system_items msi, mtl_units_of_measure muom
880: where msi.inventory_item_id = p_item_id
881: and msi.organization_id = p_org_id
882: and msi.secondary_uom_code = muom.uom_code(+);
883:

Line 948: from mtl_units_of_measure

944: if p_uom_code is NOT NULL THEN
945: begin
946: select unit_of_measure
947: into x_unit_of_measure
948: from mtl_units_of_measure
949: where uom_code = p_uom_code;
950:
951: x_progress := '002';
952: exception when no_data_found then