VIEW: APPS.GL_ELIM_SET_HISTORY_V

Source

View Text - Preformatted

SELECT els.elimination_set_id ELIMINATION_SET_ID, els.name NAME, els.ledger_id LEDGER_ID, gl.name LEDGER_NAME, els.last_executed_period LAST_EXECUTED_PERIOD, els.last_updated_by LAST_UPDATED_BY, els.last_update_date LAST_UPDATE_DATE, els.created_by CREATED_BY, els.creation_date CREATION_DATE, els.last_update_login LAST_UPDATE_LOGIN, decode(els.security_flag,'Y', decode(fnd_data_security.check_function(1.0,'GL_DAS_ELIMINATION_SET_V', 'GL_DAS_ELIMINATION_SET', to_char(els.elimination_set_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') VIEW_PRIVILEGE, decode(els.security_flag,'Y', decode(fnd_data_security.check_function(1.0,'GL_DAS_ELIMINATION_SET_U', 'GL_DAS_ELIMINATION_SET', to_char(els.elimination_set_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') USE_PRIVILEGE FROM gl_elimination_sets els, gl_ledgers gl WHERE gl.ledger_id = els.ledger_id

View Text - HTML Formatted

SELECT ELS.ELIMINATION_SET_ID ELIMINATION_SET_ID
, ELS.NAME NAME
, ELS.LEDGER_ID LEDGER_ID
, GL.NAME LEDGER_NAME
, ELS.LAST_EXECUTED_PERIOD LAST_EXECUTED_PERIOD
, ELS.LAST_UPDATED_BY LAST_UPDATED_BY
, ELS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ELS.CREATED_BY CREATED_BY
, ELS.CREATION_DATE CREATION_DATE
, ELS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DECODE(ELS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_ELIMINATION_SET_V'
, 'GL_DAS_ELIMINATION_SET'
, TO_CHAR(ELS.ELIMINATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(ELS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_ELIMINATION_SET_U'
, 'GL_DAS_ELIMINATION_SET'
, TO_CHAR(ELS.ELIMINATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
FROM GL_ELIMINATION_SETS ELS
, GL_LEDGERS GL
WHERE GL.LEDGER_ID = ELS.LEDGER_ID