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.INV_ITEM_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 3184: FROM mtl_units_of_measure_vl

3180: -- Primary_Unit_of_Measure lookup
3181:
3182: SELECT unit_of_measure --* Bug 5192495 reverted Bug 4465182 Select translated unit of measure value
3183: INTO l_Primary_Unit_of_Measure
3184: FROM mtl_units_of_measure_vl
3185: WHERE uom_code = P_Item_Rec.PRIMARY_UOM_CODE;
3186:
3187: -- Get derived attribute values.
3188: -- Service Item, Warranty, Usage flag attributes are dependent on

Line 4200: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)

4196: --added to check if sec uom class is mismatched
4197:
4198: PROCEDURE check_mismatch_of_secuom_class(
4199: p_inventory_item_id IN NUMBER
4200: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
4201: IS
4202: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
4203: SELECT muomv.UOM_CLASS
4204: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib

Line 4204: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib

4200: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
4201: IS
4202: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
4203: SELECT muomv.UOM_CLASS
4204: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib
4205: WHERE muomv.uom_code = msib.secondary_uom_code
4206: AND msib.inventory_item_id = Vinventory_item_id
4207: AND msib.secondary_uom_code IS NOT NULL
4208: AND ROWNUM = 1;

Line 4210: l_sec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;

4206: AND msib.inventory_item_id = Vinventory_item_id
4207: AND msib.secondary_uom_code IS NOT NULL
4208: AND ROWNUM = 1;
4209:
4210: l_sec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4211: BEGIN
4212: --check for uom class in other orgs
4213: OPEN c_check_sec_uom_class(Vinventory_item_id => p_inventory_item_id);
4214: FETCH c_check_sec_uom_class INTO l_sec_uom_class;

Line 4241: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE

4237: ,P_Default_Receiving_Sub_Inv IN VARCHAR2
4238: ,P_Default_Shipping_Sub_Inv IN VARCHAR2)
4239: IS
4240:
4241: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE
4242: /* Bug 3713912 */ ,cp_uom_code mtl_units_of_measure_vl.uom_code%TYPE) IS
4243: SELECT UOM_CLASS
4244: FROM MTL_UNITS_OF_MEASURE_VL
4245: WHERE UNIT_OF_MEASURE = cp_uom

Line 4242: /* Bug 3713912 */ ,cp_uom_code mtl_units_of_measure_vl.uom_code%TYPE) IS

4238: ,P_Default_Shipping_Sub_Inv IN VARCHAR2)
4239: IS
4240:
4241: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE
4242: /* Bug 3713912 */ ,cp_uom_code mtl_units_of_measure_vl.uom_code%TYPE) IS
4243: SELECT UOM_CLASS
4244: FROM MTL_UNITS_OF_MEASURE_VL
4245: WHERE UNIT_OF_MEASURE = cp_uom
4246: OR uom_code = cp_uom_code;

Line 4244: FROM MTL_UNITS_OF_MEASURE_VL

4240:
4241: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE
4242: /* Bug 3713912 */ ,cp_uom_code mtl_units_of_measure_vl.uom_code%TYPE) IS
4243: SELECT UOM_CLASS
4244: FROM MTL_UNITS_OF_MEASURE_VL
4245: WHERE UNIT_OF_MEASURE = cp_uom
4246: OR uom_code = cp_uom_code;
4247:
4248: Cursor c_get_item_count(cp_Org_Id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

Line 4258: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;

4254: AND ORGANIZATION_ID = cp_org_id;
4255:
4256: l_item_count NUMBER :=0;
4257: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4258: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4259: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4260: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4261: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4262: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

Line 4261: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;

4257: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4258: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4259: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4260: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4261: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4262: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4263: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
4264: l_catalog_grp_id NUMBER;
4265: l_folder_item_cat_id NUMBER := NULL;

Line 4262: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

4258: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4259: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4260: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4261: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4262: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4263: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
4264: l_catalog_grp_id NUMBER;
4265: l_folder_item_cat_id NUMBER := NULL;
4266: /* Bug 3713912 */

Line 4267: l_rec_sec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

4263: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
4264: l_catalog_grp_id NUMBER;
4265: l_folder_item_cat_id NUMBER := NULL;
4266: /* Bug 3713912 */
4267: l_rec_sec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4268: l_master_org VARCHAR2(1);
4269: BEGIN
4270: --Jalaj Srivastava Bug 5017588
4271: IF (P_Item_rec.secondary_uom_code IS NOT NULL) THEN

Line 4561: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE) IS

4557: ,P_Default_Receiving_Sub_Inv IN VARCHAR2
4558: ,P_Default_Shipping_Sub_Inv IN VARCHAR2
4559: ) IS
4560:
4561: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE) IS
4562: SELECT UOM_CLASS
4563: FROM MTL_UNITS_OF_MEASURE_VL
4564: WHERE UNIT_OF_MEASURE = cp_uom;
4565:

Line 4563: FROM MTL_UNITS_OF_MEASURE_VL

4559: ) IS
4560:
4561: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE) IS
4562: SELECT UOM_CLASS
4563: FROM MTL_UNITS_OF_MEASURE_VL
4564: WHERE UNIT_OF_MEASURE = cp_uom;
4565:
4566: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4567: l_folder_item_cat_id NUMBER := NULL;

Line 4566: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

4562: SELECT UOM_CLASS
4563: FROM MTL_UNITS_OF_MEASURE_VL
4564: WHERE UNIT_OF_MEASURE = cp_uom;
4565:
4566: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4567: l_folder_item_cat_id NUMBER := NULL;
4568: l_cst_item_type MTL_SYSTEM_ITEMS_FVL.PLANNING_MAKE_BUY_CODE%TYPE;
4569: l_Inventory_Item_status MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE;
4570: l_event VARCHAR2(10);