APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 443: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI, MTL_UNITS_OF_MEASURE UOM

439:
440: CURSOR get_part_info(c_instance_id NUMBER) IS
441: SELECT MTL.inventory_item_id, MTL.concatenated_segments, CSI.instance_number, CSI.serial_number, CSI.quantity,
442: CSI.lot_number, UOM.unit_of_measure, CSI.object_version_number
443: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI, MTL_UNITS_OF_MEASURE UOM
444: WHERE CSI.instance_id = c_instance_id
445: AND CSI.inventory_item_id = MTL.inventory_item_id
446: AND CSI.inv_master_organization_id = MTL.organization_id
447: AND CSI.unit_of_measure = UOM.uom_code;

Line 646: FROM MTL_UNITS_OF_MEASURE_VL

642:
643: -- Cursor to get UOM meaning given UOM code
644: CURSOR get_uom_meaning_csr (c_uom_code VARCHAR2) IS
645: SELECT unit_of_measure
646: FROM MTL_UNITS_OF_MEASURE_VL
647: WHERE uom_code = c_uom_code;
648:
649: l_disp_rec get_Disposition_Details%ROWTYPE;
650: l_temp_disp_rec get_Disposition_Details%ROWTYPE;

Line 1436: FROM MTL_UNITS_OF_MEASURE_VL

1432:
1433: -- Cursor to get UOM meaning given UOM code
1434: CURSOR get_uom_meaning_csr (c_uom_code VARCHAR2) IS
1435: SELECT unit_of_measure
1436: FROM MTL_UNITS_OF_MEASURE_VL
1437: WHERE uom_code = c_uom_code;
1438:
1439: --
1440: l_api_name CONSTANT VARCHAR2(30) := 'Calc_Position_Qty';

Line 1562: MTL_UNITS_OF_MEASURE_VL UOM

1558: -- Cursor to get unit of measure for the given Control position
1559: CURSOR get_uom_for_cntrl_pos_csr (c_relationship_id NUMBER) IS
1560: SELECT unit_of_measure
1561: FROM AHL_MC_RELATIONSHIPS RELN,
1562: MTL_UNITS_OF_MEASURE_VL UOM
1563: WHERE RELN.relationship_id = c_relationship_id
1564: AND UOM.uom_code = RELN.uom_code;
1565:
1566: -- Cursor to calculate Install qty for the given Control position