Query to find Credit Memos on an AP invoice
SELECT COUNT (DISTINCT ai2.invoice_num), ai1.invoice_num
FROM ap.ap_invoices_all ai1,
ap.ap_invoice_distributions_all aid1,
ap.ap_invoices_all ai2
WHERE ...Finance
28 posts
Query to find the AP invoices that are applied to multiple Purchase Orders
SELECT COUNT (DISTINCT d.segment1), a.invoice_num
FROM ap.ap_invoices_all A,
ap.ap_invoice_distributions_all b,
po.po_distributions_all C,
po.po_headers...AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
SELECT AGREEMENT_ID,
COMMENTS,
CONS_BILLING_NUMBER,
CONVERSION_DATE,
CONVERSION_RATE,
CONVERSION_TYPE,
CREDIT_METHOD_FOR_ACCT_RULE,
CREDIT_METHOD_FOR_I...Query to find shipset and fulfilment set
SELECT order_number,
ship_set_id,
set_id fullfillment_set_id,
COUNT (DISTINCT PAYMENT_TERM_ID)
FROM (SELECT ship_set_id,
order_number,
...