VIEW: APPS.IGI_MPP_SETUP_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')