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 |