VIEW: JTF.JTF_SOURCES_ALL#

Source

View Text - Preformatted

select SOURCE_ID SOURCE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LOOKUP_CODE LOOKUP_CODE, LOOKUP_TYPE LOOKUP_TYPE, MEANING MEANING, ENABLED_FLAG ENABLED_FLAG, DESCRIPTION DESCRIPTION, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, RELATED_ID1 RELATED_ID1, RELATED_ID2 RELATED_ID2, RELATED_ID3 RELATED_ID3, RELATED_ID4 RELATED_ID4, RELATED_ID5 RELATED_ID5, RSC_LOV_SQL RSC_LOV_SQL, RSC_COL_NAME RSC_COL_NAME, ROLE_COL_NAME ROLE_COL_NAME, GROUP_COL_NAME GROUP_COL_NAME, RSC_ACCESS_LKUP RSC_ACCESS_LKUP, DENORM_VALUE_TABLE_NAME DENORM_VALUE_TABLE_NAME, DENORM_DEA_VALUE_TABLE_NAME DENORM_DEA_VALUE_TABLE_NAME, ZD_EDITION_NAME ZD_EDITION_NAME from "JTF"."JTF_SOURCES_ALL"

View Text - HTML Formatted

SELECT SOURCE_ID SOURCE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOOKUP_CODE LOOKUP_CODE
, LOOKUP_TYPE LOOKUP_TYPE
, MEANING MEANING
, ENABLED_FLAG ENABLED_FLAG
, DESCRIPTION DESCRIPTION
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, RELATED_ID1 RELATED_ID1
, RELATED_ID2 RELATED_ID2
, RELATED_ID3 RELATED_ID3
, RELATED_ID4 RELATED_ID4
, RELATED_ID5 RELATED_ID5
, RSC_LOV_SQL RSC_LOV_SQL
, RSC_COL_NAME RSC_COL_NAME
, ROLE_COL_NAME ROLE_COL_NAME
, GROUP_COL_NAME GROUP_COL_NAME
, RSC_ACCESS_LKUP RSC_ACCESS_LKUP
, DENORM_VALUE_TABLE_NAME DENORM_VALUE_TABLE_NAME
, DENORM_DEA_VALUE_TABLE_NAME DENORM_DEA_VALUE_TABLE_NAME
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "JTF"."JTF_SOURCES_ALL"