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 843: from mtl_units_of_measure_vl

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

Line 855: from mtl_units_of_measure_vl

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

Line 904: from mtl_units_of_measure_vl

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

Line 918: from mtl_units_of_measure_vl

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

Line 962: FROM mtl_units_of_measure_vl

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

Line 1075: FROM mtl_units_of_measure_vl

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

Line 1100: FROM mtl_units_of_measure_vl

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

Line 1174: from mtl_units_of_measure_vl --Bug 5174403

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