DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on MTL_UNITS_OF_MEASURE_VL

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