AP Prepayment Vendor (Oracle Fusion SQL)

Enterprise Resource Planning (ERP) Oracle Account Payables (AP-Fusion-SQL's)
1

This AP Prepayment Vendor query retrieves details of active prepayment invoices along with associated supplier and organization information. It includes supplier ID, name, type, payment currency, supplier number, payment method, and the operating unit (organization).

#Sqlquery

SELECT
  --SQL4Fusion (An Orbit Analytics Project) 
  --This query retrieves details of active prepayment invoices.
  HAOU.NAME ORGANIZATION_NAME,
  PSV.VENDOR_NAME SUPPLIER_NAME,
  PSV.SEGMENT1 SUPPLIER_NUMBER,
  PSV.VENDOR_TYPE_LOOKUP_CODE SUPPLIER_TYPE,
  AIA.INVOICE_NUM INVOICE_NUMBER, 
  PSSV.PAYMENT_CURRENCY_CODE,  
  AIA.PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD 
FROM
  AP_INVOICES_ALL AIA,
  POZ_SUPPLIERS_V PSV,
  POZ_SUPPLIER_SITES_V PSSV,
  HR_ALL_ORGANIZATION_UNITS HAOU
WHERE
  1 = 1
  AND PSV.VENDOR_ID = AIA.VENDOR_ID
  AND AIA.INVOICE_TYPE_LOOKUP_CODE = 'PREPAYMENT'
  AND HAOU.ORGANIZATION_ID = AIA.ORG_ID
  AND AIA.CANCELLED_DATE IS NULL
  AND PSSV.VENDOR_ID=PSV.VENDOR_ID