APPS.JAI_PO_OSP_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 935: FROM mtl_UNITS_OF_MEASURE

931: AND NVL( End_Date_Active, SYSDATE + 1 ) >= SYSDATE;
932:
933: CURSOR c_get_uom_code(cp_measure_code VARCHAR2) IS
934: SELECT UOM_CODE
935: FROM mtl_UNITS_OF_MEASURE
936: WHERE UNIT_OF_MEASURE = cp_measure_code;
937:
938: CURSOR v_vend_info(cp_header_id NUMBER) IS
939: SELECT vendor_site_id

Line 1346: FROM mtl_units_of_measure

1342:
1343: --*********FETCHING UNIT OF MEASURE************
1344: CURSOR c_get_uom(um varchar2) IS
1345: Select unit_of_measure
1346: FROM mtl_units_of_measure
1347: WHERE uom_code = um;
1348: -- Added for bug #13541366
1349: CURSOR c_get_uom_code(um varchar2) IS
1350: Select uom_code

Line 1351: FROM mtl_units_of_measure

1347: WHERE uom_code = um;
1348: -- Added for bug #13541366
1349: CURSOR c_get_uom_code(um varchar2) IS
1350: Select uom_code
1351: FROM mtl_units_of_measure
1352: WHERE unit_of_measure = um;
1353:
1354: /* Added for bug 14034669 *//*Start*/
1355: