eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 592: from mtl_units_of_measure cuom,

588: begin
589:
590: select buom.unit_of_measure
591: into primary_unit
592: from mtl_units_of_measure cuom,
593: mtl_units_of_measure buom
594: where cuom.unit_of_measure = current_unit_of_measure
595: and cuom.uom_class = buom.uom_class
596: and buom.base_uom_flag = 'Y';

Line 593: mtl_units_of_measure buom

589:
590: select buom.unit_of_measure
591: into primary_unit
592: from mtl_units_of_measure cuom,
593: mtl_units_of_measure buom
594: where cuom.unit_of_measure = current_unit_of_measure
595: and cuom.uom_class = buom.uom_class
596: and buom.base_uom_flag = 'Y';
597:

Line 957: from mtl_system_items msi, mtl_units_of_measure muom

953: if (p_item_id is not null) then
954: begin
955: select msi.tracking_quantity_ind,msi.secondary_uom_code, muom.unit_of_measure
956: into l_tracking_quantity_ind, x_secondary_uom_code,x_secondary_unit_of_measure
957: from mtl_system_items msi, mtl_units_of_measure muom
958: where msi.inventory_item_id = p_item_id
959: and msi.organization_id = p_org_id
960: and msi.secondary_uom_code = muom.uom_code(+);
961:

Line 1026: from mtl_units_of_measure

1022: if p_uom_code is NOT NULL THEN
1023: begin
1024: select unit_of_measure
1025: into x_unit_of_measure
1026: from mtl_units_of_measure
1027: where uom_code = p_uom_code;
1028:
1029: x_progress := '002';
1030: exception when no_data_found then

Line 1077: l_base_fuom_flag mtl_units_of_measure.base_uom_flag%TYPE;

1073: L_RATE1 NUMBER := 1;
1074:
1075: --For interclass Bug15932062
1076: -- From UOM
1077: l_base_fuom_flag mtl_units_of_measure.base_uom_flag%TYPE;
1078: l_fuom_class mtl_units_of_measure.uom_class%TYPE;
1079: l_base_fuom mtl_units_of_measure.unit_of_measure%TYPE;
1080: -- To UOM
1081: l_base_tuom_flag mtl_units_of_measure.base_uom_flag%TYPE;

Line 1078: l_fuom_class mtl_units_of_measure.uom_class%TYPE;

1074:
1075: --For interclass Bug15932062
1076: -- From UOM
1077: l_base_fuom_flag mtl_units_of_measure.base_uom_flag%TYPE;
1078: l_fuom_class mtl_units_of_measure.uom_class%TYPE;
1079: l_base_fuom mtl_units_of_measure.unit_of_measure%TYPE;
1080: -- To UOM
1081: l_base_tuom_flag mtl_units_of_measure.base_uom_flag%TYPE;
1082: l_tuom_class mtl_units_of_measure.uom_class%TYPE;

Line 1079: l_base_fuom mtl_units_of_measure.unit_of_measure%TYPE;

1075: --For interclass Bug15932062
1076: -- From UOM
1077: l_base_fuom_flag mtl_units_of_measure.base_uom_flag%TYPE;
1078: l_fuom_class mtl_units_of_measure.uom_class%TYPE;
1079: l_base_fuom mtl_units_of_measure.unit_of_measure%TYPE;
1080: -- To UOM
1081: l_base_tuom_flag mtl_units_of_measure.base_uom_flag%TYPE;
1082: l_tuom_class mtl_units_of_measure.uom_class%TYPE;
1083: l_base_tuom mtl_units_of_measure.unit_of_measure%TYPE;

Line 1081: l_base_tuom_flag mtl_units_of_measure.base_uom_flag%TYPE;

1077: l_base_fuom_flag mtl_units_of_measure.base_uom_flag%TYPE;
1078: l_fuom_class mtl_units_of_measure.uom_class%TYPE;
1079: l_base_fuom mtl_units_of_measure.unit_of_measure%TYPE;
1080: -- To UOM
1081: l_base_tuom_flag mtl_units_of_measure.base_uom_flag%TYPE;
1082: l_tuom_class mtl_units_of_measure.uom_class%TYPE;
1083: l_base_tuom mtl_units_of_measure.unit_of_measure%TYPE;
1084:
1085: x_progress varchar2(3) := NULL;

Line 1082: l_tuom_class mtl_units_of_measure.uom_class%TYPE;

1078: l_fuom_class mtl_units_of_measure.uom_class%TYPE;
1079: l_base_fuom mtl_units_of_measure.unit_of_measure%TYPE;
1080: -- To UOM
1081: l_base_tuom_flag mtl_units_of_measure.base_uom_flag%TYPE;
1082: l_tuom_class mtl_units_of_measure.uom_class%TYPE;
1083: l_base_tuom mtl_units_of_measure.unit_of_measure%TYPE;
1084:
1085: x_progress varchar2(3) := NULL;
1086: --For interclass end Bug15932062

Line 1083: l_base_tuom mtl_units_of_measure.unit_of_measure%TYPE;

1079: l_base_fuom mtl_units_of_measure.unit_of_measure%TYPE;
1080: -- To UOM
1081: l_base_tuom_flag mtl_units_of_measure.base_uom_flag%TYPE;
1082: l_tuom_class mtl_units_of_measure.uom_class%TYPE;
1083: l_base_tuom mtl_units_of_measure.unit_of_measure%TYPE;
1084:
1085: x_progress varchar2(3) := NULL;
1086: --For interclass end Bug15932062
1087:

Line 1106: FROM MTL_UNITS_OF_MEASURE

1102: x_progress := '001';
1103:
1104: SELECT BASE_UOM_FLAG, uom_CLASS
1105: INTO l_base_fuom_flag, l_fuom_class
1106: FROM MTL_UNITS_OF_MEASURE
1107: WHERE UNIT_OF_MEASURE = P_FROM_UOM
1108: AND nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate) ;
1109:
1110:

Line 1115: FROM MTL_UNITS_OF_MEASURE

1111: x_progress := '002';
1112:
1113: SELECT BASE_UOM_FLAG, uom_CLASS
1114: INTO l_base_tuom_flag, l_tuom_class
1115: FROM MTL_UNITS_OF_MEASURE
1116: WHERE UNIT_OF_MEASURE = P_TO_UOM
1117: AND nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate) ;
1118:
1119:

Line 1126: FROM MTL_UNITS_OF_MEASURE

1122: l_base_fuom :=P_FROM_UOM;
1123: ELSE
1124: SELECT DISTINCT UNIT_OF_MEASURE
1125: INTO l_base_fuom
1126: FROM MTL_UNITS_OF_MEASURE
1127: WHERE uom_CLASS=l_fuom_class
1128: AND BASE_UOM_FLAG='Y'
1129: AND nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);
1130: END IF;

Line 1139: FROM MTL_UNITS_OF_MEASURE

1135: l_base_tuom :=P_to_UOM;
1136: ELSE
1137: SELECT DISTINCT UNIT_OF_MEASURE
1138: INTO l_base_tuom
1139: FROM MTL_UNITS_OF_MEASURE
1140: WHERE uom_CLASS=l_tuom_class
1141: AND BASE_UOM_FLAG='Y'
1142: AND nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);
1143: END IF;