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 3445: FROM mtl_units_of_measure_vl

3441: -- Primary_Unit_of_Measure lookup
3442:
3443: SELECT unit_of_measure --* Bug 5192495 reverted Bug 4465182 Select translated unit of measure value
3444: INTO l_Primary_Unit_of_Measure
3445: FROM mtl_units_of_measure_vl
3446: WHERE uom_code = P_Item_Rec.PRIMARY_UOM_CODE;
3447:
3448: -- Get derived attribute values.
3449: -- Service Item, Warranty, Usage flag attributes are dependent on

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

4461: --added to check if sec uom class is mismatched
4462:
4463: PROCEDURE check_mismatch_of_secuom_class(
4464: p_inventory_item_id IN NUMBER
4465: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
4466: IS
4467: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
4468: SELECT muomv.UOM_CLASS
4469: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib

Line 4469: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib

4465: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
4466: IS
4467: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
4468: SELECT muomv.UOM_CLASS
4469: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib
4470: WHERE muomv.uom_code = msib.secondary_uom_code
4471: AND msib.inventory_item_id = Vinventory_item_id
4472: AND msib.secondary_uom_code IS NOT NULL
4473: AND ROWNUM = 1;

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

4471: AND msib.inventory_item_id = Vinventory_item_id
4472: AND msib.secondary_uom_code IS NOT NULL
4473: AND ROWNUM = 1;
4474:
4475: l_sec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4476: BEGIN
4477: --check for uom class in other orgs
4478: OPEN c_check_sec_uom_class(Vinventory_item_id => p_inventory_item_id);
4479: FETCH c_check_sec_uom_class INTO l_sec_uom_class;

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

4502: ,P_Default_Receiving_Sub_Inv IN VARCHAR2
4503: ,P_Default_Shipping_Sub_Inv IN VARCHAR2)
4504: IS
4505:
4506: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE
4507: /* Bug 3713912 */ ,cp_uom_code mtl_units_of_measure_vl.uom_code%TYPE) IS
4508: SELECT UOM_CLASS
4509: FROM MTL_UNITS_OF_MEASURE_VL
4510: WHERE UNIT_OF_MEASURE = cp_uom

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

4503: ,P_Default_Shipping_Sub_Inv IN VARCHAR2)
4504: IS
4505:
4506: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE
4507: /* Bug 3713912 */ ,cp_uom_code mtl_units_of_measure_vl.uom_code%TYPE) IS
4508: SELECT UOM_CLASS
4509: FROM MTL_UNITS_OF_MEASURE_VL
4510: WHERE UNIT_OF_MEASURE = cp_uom
4511: OR uom_code = cp_uom_code;

Line 4509: FROM MTL_UNITS_OF_MEASURE_VL

4505:
4506: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE
4507: /* Bug 3713912 */ ,cp_uom_code mtl_units_of_measure_vl.uom_code%TYPE) IS
4508: SELECT UOM_CLASS
4509: FROM MTL_UNITS_OF_MEASURE_VL
4510: WHERE UNIT_OF_MEASURE = cp_uom
4511: OR uom_code = cp_uom_code;
4512:
4513: Cursor c_get_item_count(cp_Org_Id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

Line 4523: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;

4519: AND ORGANIZATION_ID = cp_org_id;
4520:
4521: l_item_count NUMBER :=0;
4522: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4523: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4524: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4525: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4526: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4527: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

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

4522: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4523: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4524: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4525: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4526: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4527: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4528: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
4529: l_catalog_grp_id NUMBER;
4530: l_folder_item_cat_id NUMBER := NULL;

Line 4527: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

4523: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4524: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4525: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4526: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4527: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4528: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
4529: l_catalog_grp_id NUMBER;
4530: l_folder_item_cat_id NUMBER := NULL;
4531: /* Bug 3713912 */

Line 4532: l_rec_sec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

4528: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
4529: l_catalog_grp_id NUMBER;
4530: l_folder_item_cat_id NUMBER := NULL;
4531: /* Bug 3713912 */
4532: l_rec_sec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4533: l_master_org VARCHAR2(1);
4534: BEGIN
4535: --Jalaj Srivastava Bug 5017588
4536: IF (P_Item_rec.secondary_uom_code IS NOT NULL) THEN

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

4822: ,P_Default_Receiving_Sub_Inv IN VARCHAR2
4823: ,P_Default_Shipping_Sub_Inv IN VARCHAR2
4824: ) IS
4825:
4826: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE) IS
4827: SELECT UOM_CLASS
4828: FROM MTL_UNITS_OF_MEASURE_VL
4829: WHERE UNIT_OF_MEASURE = cp_uom;
4830:

Line 4828: FROM MTL_UNITS_OF_MEASURE_VL

4824: ) IS
4825:
4826: Cursor c_get_uom_class(cp_uom mtl_units_of_measure_vl.unit_of_measure%TYPE) IS
4827: SELECT UOM_CLASS
4828: FROM MTL_UNITS_OF_MEASURE_VL
4829: WHERE UNIT_OF_MEASURE = cp_uom;
4830:
4831: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4832: l_folder_item_cat_id NUMBER := NULL;

Line 4831: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

4827: SELECT UOM_CLASS
4828: FROM MTL_UNITS_OF_MEASURE_VL
4829: WHERE UNIT_OF_MEASURE = cp_uom;
4830:
4831: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4832: l_folder_item_cat_id NUMBER := NULL;
4833: l_cst_item_type MTL_SYSTEM_ITEMS_FVL.PLANNING_MAKE_BUY_CODE%TYPE;
4834: l_Inventory_Item_status MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE;
4835: l_event VARCHAR2(10);