DBA Data[Home] [Help]

VIEW: APPS.IGS_GE_CFG_TAB_V

Source

View Text - Preformatted

SELECT t.rowid row_id, t.responsibility_id, t.form_code, t.tab_code, l1.meaning tab_meaning, l1.tag block_name, t.config_opt, t.created_by, t.creation_date, t.last_updated_by, t.last_update_date, t.last_update_login FROM igs_ge_cfg_tab t, fnd_lookup_values l1 WHERE l1.lookup_code = t.tab_code AND l1.lookup_type = 'GE_CFG_TAB' AND l1.language = USERENV('LANG') AND l1.view_application_id = 8405 AND l1.security_group_id = 0 AND l1.enabled_flag='Y'
View Text - HTML Formatted

SELECT T.ROWID ROW_ID
, T.RESPONSIBILITY_ID
, T.FORM_CODE
, T.TAB_CODE
, L1.MEANING TAB_MEANING
, L1.TAG BLOCK_NAME
, T.CONFIG_OPT
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
FROM IGS_GE_CFG_TAB T
, FND_LOOKUP_VALUES L1
WHERE L1.LOOKUP_CODE = T.TAB_CODE
AND L1.LOOKUP_TYPE = 'GE_CFG_TAB'
AND L1.LANGUAGE = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID = 8405
AND L1.SECURITY_GROUP_ID = 0
AND L1.ENABLED_FLAG='Y'