DBA Data[Home] [Help]

APPS.JAI_PO_OSP_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 814: FROM mtl_UNITS_OF_MEASURE

810: AND NVL( End_Date_Active, SYSDATE + 1 ) >= SYSDATE;
811:
812: CURSOR c_get_uom_code(cp_measure_code VARCHAR2) IS
813: SELECT UOM_CODE
814: FROM mtl_UNITS_OF_MEASURE
815: WHERE UNIT_OF_MEASURE = cp_measure_code;
816:
817: CURSOR v_vend_info(cp_header_id NUMBER) IS
818: SELECT vendor_site_id

Line 1223: FROM mtl_units_of_measure

1219:
1220: --*********FETCHING UNIT OF MEASURE************
1221: CURSOR c_get_uom(um varchar2) IS
1222: Select unit_of_measure
1223: FROM mtl_units_of_measure
1224: WHERE uom_code = um;
1225:
1226: -- sriram - bug # 3021456
1227: cursor c_po_qty_cur(p_po_hdr_id number , p_po_line_id number) is