Oracle Q&A
12345678910111213141516171819202122232425262728function get_qty_per_pallet(p_invoice_line_id in number) return number is l_return number; begin begin select distinct spm.pallet_stack_qty * spm.qty_carton_per_stack * spm.fg_item_per_carton into l_return from som_commercial_invoice_lines scl,...
more...