DBA Data[Home] [Help]

APPS.GHG_TRANSACTIONS_API_PKG dependencies on AP_INVOICES_ALL

Line 910: FROM ap_invoices_all ap

906: AND em.transaction_source_id = nvl(p_source_id, em.transaction_source_id)
907: AND (trunc(em.transaction_date_from) between nvl(v_emission_from_date, em.transaction_date_from) and nvl(v_emission_to_date, em.transaction_date_to)
908: OR trunc(em.transaction_date_to) between nvl(v_emission_from_date, em.transaction_date_from) and nvl(v_emission_to_date, em.transaction_date_to))
909: AND EXISTS (SELECT 1
910: FROM ap_invoices_all ap
911: WHERE ap.invoice_id = em.invoice_id
912: AND ap.vendor_id = p_supplier_id);
913:
914: