View: IGI_CBR_AP_INV_DIST_V

Product:	IGI - Public Sector Financials International
Description:	This view returns all the invoice distributions that have been posted
Implementation/DBA Data:	APPS.IGI_CBR_AP_INV_DIST_V

View Text

SELECT AI.INVOICE_ID
, ID.DIST_CODE_COMBINATION_ID
, SUM(DECODE(AI.INVOICE_CURRENCY_CODE
, ASP.BASE_CURRENCY_CODE
, ID.AMOUNT
, ID.BASE_AMOUNT)) AMOUNT FROM AP_SYSTEM_PARAMETERS_ALL ASP
, AP_INVOICE_DISTRIBUTIONS_ALL ID
, AP_INVOICES_ALL AI
WHERE AI.INVOICE_ID = ID.INVOICE_ID AND ASP.SET_OF_BOOKS_ID = ID.SET_OF_BOOKS_ID AND NVL(ID.ORG_ID
, -1) = NVL(ASP.ORG_ID
, -1) GROUP BY AI.INVOICE_ID
, ID.DIST_CODE_COMBINATION_ID HAVING SUM(DECODE(AI.INVOICE_CURRENCY_CODE
, ASP.BASE_CURRENCY_CODE
, ID.AMOUNT
, ID.BASE_AMOUNT)) != 0

Columns