View: IGI_MPP_EXP_RECOGNITION

Product:	IGI - Public Sector Financials International
Description:	Used for Multi Period Posting expense recognition
Implementation/DBA Data:	APPS.IGI_MPP_EXP_RECOGNITION

View Text

SELECT AIV.INVOICE_CURRENCY_CODE
, MPP_DIST.DISTRIBUTION_LINE_NUMBER
, AIV.VENDOR_NAME
, AIV.VENDOR_SITE_CODE
, AIV.INVOICE_TYPE_LOOKUP_CODE
, AIDV.ACCOUNTING_DATE
, NVL(MPP_DIST.ENTERED_DR
, 0) + NVL(MPP_DIST.ENTERED_CR
, 0) AMOUNT
, NVL(MPP_DIST.ENTERED_DR
, 0) ENTERED_DR
, NVL(MPP_DIST.ENTERED_CR
, 0) ENTERED_CR
, NVL(MPP_DIST.ACCOUNTED_DR
, 0) ACCOUNTED_DR
, NVL(MPP_DIST.ACCOUNTED_CR
, 0) ACCOUNTED_CR
, MPP_DIST.CODE_COMBINATION_ID
, MPP_DIST.PERIOD_NAME
, NVL(AIV.BATCH_ID
, -1) BATCH_ID
, AIV.INVOICE_ID
, AIV.SET_OF_BOOKS_ID
, GSOB.CHART_OF_ACCOUNTS_ID
, AIV.INVOICE_NUM
, GPS.EFFECTIVE_PERIOD_NUM
, GPS.START_DATE
, GPS.END_DATE
, MPP_DIST.REFERENCE1 MPP_DIST_LINE_NUMBER
, MPP_DIST.EXPENSE_RECOGNIZED_FLAG
, MPP_DIST.SUBLEDGER_ENTRY_ID
FROM AP_INVOICES_V AIV
, AP_INVOICE_DISTRIBUTIONS_V AIDV
, GL_PERIOD_STATUSES GPS
, GL_SETS_OF_BOOKS GSOB
, IGI_MPP_SUBLEDGER MPP_DIST
WHERE AIV.INVOICE_ID = AIDV.INVOICE_ID
AND AIDV.INVOICE_ID = MPP_DIST.INVOICE_ID
AND AIV.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND AIDV.DISTRIBUTION_LINE_NUMBER = MPP_DIST.DISTRIBUTION_LINE_NUMBER
AND GPS.SET_OF_BOOKS_ID = AIDV.SET_OF_BOOKS_ID
AND GPS.APPLICATION_ID = 200
AND GPS.PERIOD_NAME = MPP_DIST.PERIOD_NAME ORDER BY GPS.PERIOD_NUM
, GPS.PERIOD_YEAR
, AIV.VENDOR_NAME
, AIV.INVOICE_NUM
, MPP_DIST.REFERENCE1

Columns