VIEW: JTF.JTY_DENORM_DEA_RULES_ALL#

Source

View Text - Preformatted

select TERR_ID TERR_ID, 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, RANK RANK, LEVEL_FROM_ROOT LEVEL_FROM_ROOT, LEVEL_FROM_PARENT LEVEL_FROM_PARENT, IMMEDIATE_PARENT_FLAG IMMEDIATE_PARENT_FLAG, ORG_ID ORG_ID, RELATED_TERR_ID RELATED_TERR_ID, TOP_LEVEL_TERR_ID TOP_LEVEL_TERR_ID, NUM_WINNERS NUM_WINNERS, ABSOLUTE_RANK ABSOLUTE_RANK, START_DATE START_DATE, END_DATE END_DATE, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JTF"."JTY_DENORM_DEA_RULES_ALL"

View Text - HTML Formatted

SELECT TERR_ID TERR_ID
, 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
, RANK RANK
, LEVEL_FROM_ROOT LEVEL_FROM_ROOT
, LEVEL_FROM_PARENT LEVEL_FROM_PARENT
, IMMEDIATE_PARENT_FLAG IMMEDIATE_PARENT_FLAG
, ORG_ID ORG_ID
, RELATED_TERR_ID RELATED_TERR_ID
, TOP_LEVEL_TERR_ID TOP_LEVEL_TERR_ID
, NUM_WINNERS NUM_WINNERS
, ABSOLUTE_RANK ABSOLUTE_RANK
, START_DATE START_DATE
, END_DATE END_DATE
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JTF"."JTY_DENORM_DEA_RULES_ALL"