VIEW: JTF.JTF_TAE_RPT_STAGING_OUT#

Source

View Text - Preformatted

select TRANS_OBJECT_ID TRANS_OBJECT_ID, TRANS_DETAIL_OBJECT_ID TRANS_DETAIL_OBJECT_ID, HEADER_ID1 HEADER_ID1, HEADER_ID2 HEADER_ID2, SOURCE_ID SOURCE_ID, TRANS_OBJECT_TYPE_ID TRANS_OBJECT_TYPE_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, SESSION_ID SESSION_ID, AT_CHAR01 AT_CHAR01, AT_CHAR02 AT_CHAR02, AT_CHAR03 AT_CHAR03, AT_CHAR04 AT_CHAR04, AT_CHAR05 AT_CHAR05, AT_CHAR06 AT_CHAR06, AT_CHAR07 AT_CHAR07, AT_CHAR08 AT_CHAR08, AT_CHAR09 AT_CHAR09, AT_CHAR10 AT_CHAR10, AT_CHAR11 AT_CHAR11, AT_CHAR12 AT_CHAR12, AT_CHAR13 AT_CHAR13, AT_CHAR14 AT_CHAR14, AT_CHAR15 AT_CHAR15, AT_CHAR16 AT_CHAR16, AT_CHAR17 AT_CHAR17, AT_CHAR18 AT_CHAR18, AT_CHAR19 AT_CHAR19, AT_CHAR20 AT_CHAR20, AT_NUM01 AT_NUM01, AT_NUM02 AT_NUM02, AT_NUM03 AT_NUM03, AT_NUM04 AT_NUM04, AT_NUM05 AT_NUM05, AT_NUM06 AT_NUM06, AT_NUM07 AT_NUM07, AT_NUM08 AT_NUM08, AT_NUM09 AT_NUM09, AT_NUM10 AT_NUM10, AT_NUM11 AT_NUM11, AT_NUM12 AT_NUM12, AT_NUM13 AT_NUM13, AT_NUM14 AT_NUM14, AT_NUM15 AT_NUM15, AT_NUM16 AT_NUM16, AT_NUM17 AT_NUM17, AT_NUM18 AT_NUM18, AT_NUM19 AT_NUM19, AT_NUM20 AT_NUM20, TERR_ID TERR_ID, TERR_NAME TERR_NAME, TERR_RANK TERR_RANK, RELATED_TERR_ID RELATED_TERR_ID, RELATED_TERR_NAME RELATED_TERR_NAME, RESOURCE_ID RESOURCE_ID, RESOURCE_TYPE RESOURCE_TYPE, PERSON_ID PERSON_ID, RESOURCE_NAME RESOURCE_NAME, GROUP_ID GROUP_ID, GROUP_NAME GROUP_NAME, ROLE ROLE, ROLE_NAME ROLE_NAME, TERR_QUAL_ID TERR_QUAL_ID, QUAL_USG_ID QUAL_USG_ID, QUALIFIER_NAME QUALIFIER_NAME, TERR_VALUE_ID TERR_VALUE_ID, LOW_VALUE_CHAR LOW_VALUE_CHAR, HIGH_VALUE_CHAR HIGH_VALUE_CHAR, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JTF"."JTF_TAE_RPT_STAGING_OUT"

View Text - HTML Formatted

SELECT TRANS_OBJECT_ID TRANS_OBJECT_ID
, TRANS_DETAIL_OBJECT_ID TRANS_DETAIL_OBJECT_ID
, HEADER_ID1 HEADER_ID1
, HEADER_ID2 HEADER_ID2
, SOURCE_ID SOURCE_ID
, TRANS_OBJECT_TYPE_ID TRANS_OBJECT_TYPE_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
, SESSION_ID SESSION_ID
, AT_CHAR01 AT_CHAR01
, AT_CHAR02 AT_CHAR02
, AT_CHAR03 AT_CHAR03
, AT_CHAR04 AT_CHAR04
, AT_CHAR05 AT_CHAR05
, AT_CHAR06 AT_CHAR06
, AT_CHAR07 AT_CHAR07
, AT_CHAR08 AT_CHAR08
, AT_CHAR09 AT_CHAR09
, AT_CHAR10 AT_CHAR10
, AT_CHAR11 AT_CHAR11
, AT_CHAR12 AT_CHAR12
, AT_CHAR13 AT_CHAR13
, AT_CHAR14 AT_CHAR14
, AT_CHAR15 AT_CHAR15
, AT_CHAR16 AT_CHAR16
, AT_CHAR17 AT_CHAR17
, AT_CHAR18 AT_CHAR18
, AT_CHAR19 AT_CHAR19
, AT_CHAR20 AT_CHAR20
, AT_NUM01 AT_NUM01
, AT_NUM02 AT_NUM02
, AT_NUM03 AT_NUM03
, AT_NUM04 AT_NUM04
, AT_NUM05 AT_NUM05
, AT_NUM06 AT_NUM06
, AT_NUM07 AT_NUM07
, AT_NUM08 AT_NUM08
, AT_NUM09 AT_NUM09
, AT_NUM10 AT_NUM10
, AT_NUM11 AT_NUM11
, AT_NUM12 AT_NUM12
, AT_NUM13 AT_NUM13
, AT_NUM14 AT_NUM14
, AT_NUM15 AT_NUM15
, AT_NUM16 AT_NUM16
, AT_NUM17 AT_NUM17
, AT_NUM18 AT_NUM18
, AT_NUM19 AT_NUM19
, AT_NUM20 AT_NUM20
, TERR_ID TERR_ID
, TERR_NAME TERR_NAME
, TERR_RANK TERR_RANK
, RELATED_TERR_ID RELATED_TERR_ID
, RELATED_TERR_NAME RELATED_TERR_NAME
, RESOURCE_ID RESOURCE_ID
, RESOURCE_TYPE RESOURCE_TYPE
, PERSON_ID PERSON_ID
, RESOURCE_NAME RESOURCE_NAME
, GROUP_ID GROUP_ID
, GROUP_NAME GROUP_NAME
, ROLE ROLE
, ROLE_NAME ROLE_NAME
, TERR_QUAL_ID TERR_QUAL_ID
, QUAL_USG_ID QUAL_USG_ID
, QUALIFIER_NAME QUALIFIER_NAME
, TERR_VALUE_ID TERR_VALUE_ID
, LOW_VALUE_CHAR LOW_VALUE_CHAR
, HIGH_VALUE_CHAR HIGH_VALUE_CHAR
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JTF"."JTF_TAE_RPT_STAGING_OUT"