1. Tables and Views for Procurement
  2. POZ_BI_SUP_SITES_AP_INV_DIST_V

POZ_BI_SUP_SITES_AP_INV_DIST_V

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: VIEW

Columns

Name

VENDOR_SITE_ID

AMOUNT

Query

SQL_Statement

SELECT

INV_HEADER.VENDOR_SITE_ID AS VENDOR_SITE_ID,

SUM(INV_DIST.AMOUNT ) AS AMOUNT

FROM

AP_INVOICES_ALL INV_HEADER,

AP_INVOICE_DISTRIBUTIONS_ALL INV_DIST

WHERE

INV_HEADER.INVOICE_ID = INV_DIST.INVOICE_ID

AND INV_HEADER.WFAPPROVAL_STATUS IN ('MANUALLY APPROVED','NOT REQUIRED','WFAPPROVED','APPROVED')

AND INV_HEADER.INVOICE_TYPE_LOOKUP_CODE NOT IN ('AWT', 'PREPAYMENT')

AND INV_HEADER.INVOICE_TYPE_LOOKUP_CODE IS NOT NULL

AND INV_DIST.LINE_TYPE_LOOKUP_CODE NOT IN ('AWT','PREPAY')

AND INV_DIST.MATCH_STATUS_FLAG ='A'

GROUP BY INV_HEADER.VENDOR_SITE_ID