[Home] [Help]
87: */
88:
89: CURSOR c_uom IS
90: SELECT unit_of_measure, uom_code
91: FROM mtl_units_of_measure
92: WHERE NVL( disable_date, SYSDATE+1) > SYSDATE
93: ORDER BY unit_of_measure;
94:
95: CURSOR cat_set IS
588: WHERE concatenated_segments = catname;
589:
590: CURSOR get_uom(v_uom VARCHAR2) IS
591: SELECT unit_of_measure
592: FROM mtl_units_of_measure
593: WHERE unit_of_measure = v_uom;
594:
595: BEGIN
596: