View: IGI_MPP_SETUP_V

Product:	IGI - Public Sector Financials International
Description:	View for the Multi Period Posting form based on IGI_MPP_SETUP view
Implementation/DBA Data:	APPS.IGI_MPP_SETUP_V

View Text

SELECT IMS.ROWID ROW_ID
, IMS.SET_OF_BOOKS_ID
, IMS.FUTURE_POSTING_CCID
, IMS.LAST_UPDATED_BY
, IMS.LAST_UPDATE_DATE
, IMS.CREATED_BY
, IMS.CREATION_DATE
, IMS.DEFAULT_ACCOUNTING_RULE_ID
, RA.NAME DEFAULT_ACCOUNTING_RULE_NAME
, GJC.USER_JE_CATEGORY_NAME
, IMS.JE_CATEGORY_NAME
, GJS.USER_JE_SOURCE_NAME
, IMS.JE_SOURCE_NAME
, IMS.LAST_UPDATE_LOGIN
, IMS.ORG_ID
FROM GL_JE_CATEGORIES_TL GJC
, GL_JE_SOURCES_TL GJS
, IGI_MPP_SETUP IMS
, RA_RULES RA
WHERE GJS.JE_SOURCE_NAME = IMS.JE_SOURCE_NAME
AND GJC.JE_CATEGORY_NAME = IMS.JE_CATEGORY_NAME
AND RA.RULE_ID = IMS.DEFAULT_ACCOUNTING_RULE_ID
AND RA.TYPE = 'A'
AND GJS.LANGUAGE = USERENV('LANG')
AND GJC.LANGUAGE = USERENV('LANG')

Columns