APPS.INVIDIT1 dependencies on MTL_UNITS_OF_MEASURE_VL

Line 229: mtl_units_of_measure_vl

225: unit_of_measure_tl, uom_code, uom_class
226: into
227: x_default_uom, x_default_uom_code, x_default_uom_class
228: from
229: mtl_units_of_measure_vl
230: where
231: unit_of_measure = uom_default;
232:
233: exception

Line 845: from mtl_units_of_measure_vl

841: if (X_weight_uom_code is not null) then
842: begin
843: select unit_of_measure_tl
844: into X_weight_uom
845: from mtl_units_of_measure_vl
846: where uom_code = X_weight_uom_code;
847: exception
848: when NO_DATA_FOUND then
849: X_weight_uom := null;

Line 857: from mtl_units_of_measure_vl

853: if (X_volume_uom_code is not null) then
854: begin
855: select unit_of_measure_tl
856: into X_volume_uom
857: from mtl_units_of_measure_vl
858: where uom_code = X_volume_uom_code;
859: exception
860: when NO_DATA_FOUND then
861: X_volume_uom := null;

Line 906: from mtl_units_of_measure_vl

902: if ( X_service_duration_per_code is not null ) then
903: begin
904: select unit_of_measure_tl
905: into X_service_duration_period
906: from mtl_units_of_measure_vl
907: where uom_code = X_service_duration_per_code;
908: exception
909: when NO_DATA_FOUND then
910: X_service_duration_period := null;

Line 920: from mtl_units_of_measure_vl

916: if ( p_primary_uom_code is not null ) then
917: begin
918: select unit_of_measure_tl, uom_class
919: into x_primary_uom, x_uom_class
920: from mtl_units_of_measure_vl
921: where uom_code = p_primary_uom_code;
922: exception
923: when NO_DATA_FOUND then
924: x_primary_uom := null;

Line 964: FROM mtl_units_of_measure_vl

960: IF ( p_dimension_uom_code is not null ) then
961: BEGIN
962: SELECT unit_of_measure_tl
963: INTO x_dimension_uom
964: FROM mtl_units_of_measure_vl
965: WHERE uom_code = p_dimension_uom_code;
966: EXCEPTION
967: WHEN no_data_found THEN
968: x_dimension_uom := null;

Line 1077: FROM mtl_units_of_measure_vl

1073: IF ( p_secondary_uom_code IS NOT NULL ) THEN
1074: BEGIN
1075: SELECT unit_of_measure_tl, uom_class
1076: INTO x_secondary_uom, x_secondary_uom_class
1077: FROM mtl_units_of_measure_vl
1078: WHERE uom_code = p_secondary_uom_code;
1079: EXCEPTION
1080: WHEN no_data_found THEN
1081: x_secondary_uom := NULL;

Line 1102: FROM mtl_units_of_measure_vl

1098: IF l_sec_uom_code IS NOT NULL THEN
1099: BEGIN
1100: SELECT uom_class
1101: INTO x_secondary_uom_class
1102: FROM mtl_units_of_measure_vl
1103: WHERE uom_code = l_sec_uom_code;
1104: EXCEPTION
1105: WHEN no_data_found THEN
1106: x_secondary_uom_class := NULL;

Line 1176: from mtl_units_of_measure_vl --Bug 5174403

1172:
1173: BEGIN
1174: IF X_charge_periodicity_code IS NOT NULL THEN
1175: SELECT UNIT_OF_MEASURE INTO X_charge_unit_of_measure
1176: from mtl_units_of_measure_vl --Bug 5174403
1177: WHERE UOM_CODE = X_charge_periodicity_code;
1178: END IF;
1179: EXCEPTION
1180: WHEN NO_DATA_FOUND THEN