80: plt.unit_of_measure,
81: psp.line_type_id
82: FROM po_line_types plt,
83: po_system_parameters psp,
84: mtl_categories_kfv mck
85: WHERE plt.line_type_id = psp.line_type_id
86: AND plt.category_id = mck.category_id (+);
87: */
88:
583: l_price number:= NULL;
584:
585: CURSOR getCatId(catname VARCHAR2) IS
586: SELECT category_id
587: FROM mtl_categories_kfv
588: WHERE concatenated_segments = catname;
589:
590: CURSOR get_uom(v_uom VARCHAR2) IS
591: SELECT unit_of_measure