Query to find uninvoiced receipts in Oracle apps
Query to find uninvoiced receipts in Oracle apps |
6 Important Tables to find uninvoiced receipts in Oracle apps
Detail level of Query to find uninvoiced receipts in Oracle apps
select a2.RECEIPT_NUM,
ASS.VENDOR_NAME,
AS_SITE.VENDOR_SITE_CODE,
A1.TRANSACTION_DATE "RECEIPT_DATE",
A1.PRIMARY_QUANTITY "RECEIPT_TRANSACTION_QTY",
A1.transaction_type
from
apps.rcv_shipment_headers a2,
APPS.AP_SUPPLIERS ASS,
APPS.AP_SUPPLIER_SITES_ALL AS_SITE,
apps.rcv_shipment_lines a3,
apps.rcv_transactions a1
where 1=1
AND A1.TRANSACTION_ID NOT IN (SELECT AILA.RCV_TRANSACTION_ID FROM apps.AP_INVOICES_ALL aia,apps.ap_invoice_lines_all aila
WHERE AIA.CANCELLED_BY IS NULL
AND AIA.INVOICE_ID=AILA.INVOICE_ID
AND AILA.RCV_TRANSACTION_ID IS NOT NULL)
AND ASS.VENDOR_ID=AS_SITE.VENDOR_ID
AND A2.VENDOR_SITE_ID=AS_SITE.VENDOR_SITE_ID
AND A1.transaction_type = 'RECEIVE'
and a2.shipment_header_id=a3.shipment_header_id
and a1.shipment_line_id=a3.shipment_line_id
and a2.shipment_header_id=a1.shipment_header_id
AND A2.VENDOR_ID=ASS.VENDOR_ID
Query to find uninvoiced receipts in Oracle apps |
1 comments:
Exactly what I was looking for ! Many thanks
Post a Comment