SELECT air.*
FROM ap_interface_rejections air,
ap_invoice_lines_interface aili,
ap_invoices_interface aii
WHERE aii.invoice_id = aili.invoice_id
AND aili.invoice_line_id = air.parent_id
AND aii.invoice_num = &Invoice_Num;
All about Oracle Apps. API examples, Codes and tweaks, Commands, Tips and Tricks
0 comments:
Post a Comment