[Home] [Help]
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'
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'
|
|
|
|