DBA Data[Home] [Help]

VIEW: APPS.IGS_GE_CFG_NAV_V

Source

View Text - Preformatted

SELECT t.rowid row_id, t.responsibility_id, t.form_code, t.seq_number, t.subform_code, l1.meaning subform_meaning, t.but_label, t.created_by, t.creation_date, t.last_updated_by, t.last_update_date, t.last_update_login FROM igs_ge_cfg_nav t, igs_lookup_values l1 WHERE l1.lookup_code = t.subform_code AND l1.lookup_type = 'GE_NAV_SUBFORM'
View Text - HTML Formatted

SELECT T.ROWID ROW_ID
, T.RESPONSIBILITY_ID
, T.FORM_CODE
, T.SEQ_NUMBER
, T.SUBFORM_CODE
, L1.MEANING SUBFORM_MEANING
, T.BUT_LABEL
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
FROM IGS_GE_CFG_NAV T
, IGS_LOOKUP_VALUES L1
WHERE L1.LOOKUP_CODE = T.SUBFORM_CODE
AND L1.LOOKUP_TYPE = 'GE_NAV_SUBFORM'