View: IGI_MPP_EXPENSE_RULES_V

Product:	IGI - Public Sector Financials International
Description:	Contains expense rules information required by expense rules form based on IGI_MPP_EXPENSE_RULES view
Implementation/DBA Data:	APPS.IGI_MPP_EXPENSE_RULES_V

View Text

SELECT IMER.ROWID ROW_ID
, IMER.SET_OF_BOOKS_ID
, IMER.EXPENSE_CCID
, IMER.LAST_UPDATED_BY
, IMER.LAST_UPDATE_DATE
, IMER.CREATED_BY
, IMER.CREATION_DATE
, IMER.DEFAULT_ACCOUNTING_RULE_ID
, RR.NAME DEFAULT_ACCOUNTING_RULE_NAME
, IMER.ENABLED_FLAG
, IMER.LAST_UPDATE_LOGIN
, IMER.ORG_ID
FROM IGI_MPP_EXPENSE_RULES IMER
, RA_RULES RR
WHERE RR.RULE_ID = IMER.DEFAULT_ACCOUNTING_RULE_ID

Columns