OracleAppsToday
All about Oracle Apps. API examples, Codes and tweaks, Commands, Tips and Tricks
Friday, July 4, 2014
Query to find rejection Messages during AP Interface : Oracle R12
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;
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment