SELECT ELTPI.ROWID ROW_ID, ELTPI.S_ENQUIRY_LEVEL_TYPE S_ENQUIRY_LEVEL_TYPE, ELTPI.ENQUIRY_PACKAGE_ITEM ENQUIRY_PACKAGE_ITEM, LKUP.MEANING MEANING, ELTPI.CREATED_BY CREATED_BY, ELTPI.CREATION_DATE CREATION_DATE, ELTPI.LAST_UPDATED_BY LAST_UPDATED_BY, ELTPI.LAST_UPDATE_DATE LAST_UPDATE_DATE, ELTPI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_IN_LVLTYP_PKG_IT ELTPI, IGS_LOOKUPS_VIEW LKUP WHERE LKUP.LOOKUP_TYPE = 'ENQUIRY_LEVEL_TYPE' AND LKUP.LOOKUP_CODE = ELTPI.S_ENQUIRY_LEVEL_TYPE
SELECT ELTPI.ROWID ROW_ID
, ELTPI.S_ENQUIRY_LEVEL_TYPE S_ENQUIRY_LEVEL_TYPE
, ELTPI.ENQUIRY_PACKAGE_ITEM ENQUIRY_PACKAGE_ITEM
, LKUP.MEANING MEANING
, ELTPI.CREATED_BY CREATED_BY
, ELTPI.CREATION_DATE CREATION_DATE
, ELTPI.LAST_UPDATED_BY LAST_UPDATED_BY
, ELTPI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ELTPI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_IN_LVLTYP_PKG_IT ELTPI
, IGS_LOOKUPS_VIEW LKUP
WHERE LKUP.LOOKUP_TYPE = 'ENQUIRY_LEVEL_TYPE'
AND LKUP.LOOKUP_CODE = ELTPI.S_ENQUIRY_LEVEL_TYPE
|
|
|