SELECT a.interface_line_id,
b.message_text,
a.sales_order,
a.trx_number,
a.sales_order_line,
a.amount,
a.batch_source_name
INTO &O_interface_line_id,
&O_message_text,
&O_sales_order,
&O_trx_number,
&O_sales_order_line,
&O_amount,
&O_batch_source_name
FROM ra_interface_lines_all a,
ra_interface_errors_all b
WHERE a.interface_line_id = b.interface_line_id

Return to : Oracle Database, SQL, Application, Programming Tips