DBA Data[Home] [Help]

VIEW: APPS.IGI_MPP_EXPENSE_RULES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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