VIEW: JTF.JTF_TAE_RPT_OBJS#

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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SESSION_ID SESSION_ID, SQUAL_FC01 SQUAL_FC01, SQUAL_FC02 SQUAL_FC02, SQUAL_FC03 SQUAL_FC03, SQUAL_FC04 SQUAL_FC04, SQUAL_FC05 SQUAL_FC05, SQUAL_CURC01 SQUAL_CURC01, SQUAL_CURC02 SQUAL_CURC02, SQUAL_CURC03 SQUAL_CURC03, SQUAL_CURC04 SQUAL_CURC04, SQUAL_CURC05 SQUAL_CURC05, SQUAL_CURC06 SQUAL_CURC06, SQUAL_CURC07 SQUAL_CURC07, SQUAL_CURC08 SQUAL_CURC08, SQUAL_CURC09 SQUAL_CURC09, SQUAL_CURC10 SQUAL_CURC10, SQUAL_CHAR01 SQUAL_CHAR01, SQUAL_CHAR02 SQUAL_CHAR02, SQUAL_CHAR03 SQUAL_CHAR03, SQUAL_CHAR04 SQUAL_CHAR04, SQUAL_CHAR05 SQUAL_CHAR05, SQUAL_CHAR06 SQUAL_CHAR06, SQUAL_CHAR07 SQUAL_CHAR07, SQUAL_CHAR08 SQUAL_CHAR08, SQUAL_CHAR09 SQUAL_CHAR09, SQUAL_CHAR10 SQUAL_CHAR10, SQUAL_CHAR11 SQUAL_CHAR11, SQUAL_CHAR12 SQUAL_CHAR12, SQUAL_CHAR13 SQUAL_CHAR13, SQUAL_CHAR14 SQUAL_CHAR14, SQUAL_CHAR15 SQUAL_CHAR15, SQUAL_CHAR16 SQUAL_CHAR16, SQUAL_CHAR17 SQUAL_CHAR17, SQUAL_CHAR18 SQUAL_CHAR18, SQUAL_CHAR19 SQUAL_CHAR19, SQUAL_CHAR20 SQUAL_CHAR20, SQUAL_CHAR21 SQUAL_CHAR21, SQUAL_CHAR22 SQUAL_CHAR22, SQUAL_CHAR23 SQUAL_CHAR23, SQUAL_CHAR24 SQUAL_CHAR24, SQUAL_CHAR25 SQUAL_CHAR25, SQUAL_CHAR26 SQUAL_CHAR26, SQUAL_CHAR27 SQUAL_CHAR27, SQUAL_CHAR28 SQUAL_CHAR28, SQUAL_CHAR30 SQUAL_CHAR30, SQUAL_CHAR31 SQUAL_CHAR31, SQUAL_CHAR32 SQUAL_CHAR32, SQUAL_CHAR33 SQUAL_CHAR33, SQUAL_CHAR34 SQUAL_CHAR34, SQUAL_CHAR35 SQUAL_CHAR35, SQUAL_CHAR36 SQUAL_CHAR36, SQUAL_CHAR37 SQUAL_CHAR37, SQUAL_CHAR38 SQUAL_CHAR38, SQUAL_CHAR39 SQUAL_CHAR39, SQUAL_CHAR40 SQUAL_CHAR40, SQUAL_CHAR41 SQUAL_CHAR41, SQUAL_CHAR42 SQUAL_CHAR42, SQUAL_CHAR43 SQUAL_CHAR43, SQUAL_CHAR44 SQUAL_CHAR44, SQUAL_CHAR45 SQUAL_CHAR45, SQUAL_CHAR46 SQUAL_CHAR46, SQUAL_CHAR47 SQUAL_CHAR47, SQUAL_CHAR48 SQUAL_CHAR48, SQUAL_CHAR49 SQUAL_CHAR49, SQUAL_CHAR50 SQUAL_CHAR50, SQUAL_CHAR51 SQUAL_CHAR51, SQUAL_CHAR52 SQUAL_CHAR52, SQUAL_CHAR53 SQUAL_CHAR53, SQUAL_CHAR54 SQUAL_CHAR54, SQUAL_CHAR55 SQUAL_CHAR55, SQUAL_CHAR56 SQUAL_CHAR56, SQUAL_CHAR57 SQUAL_CHAR57, SQUAL_CHAR58 SQUAL_CHAR58, SQUAL_CHAR59 SQUAL_CHAR59, SQUAL_CHAR60 SQUAL_CHAR60, SQUAL_NUM01 SQUAL_NUM01, SQUAL_NUM02 SQUAL_NUM02, SQUAL_NUM03 SQUAL_NUM03, SQUAL_NUM04 SQUAL_NUM04, SQUAL_NUM05 SQUAL_NUM05, SQUAL_NUM06 SQUAL_NUM06, SQUAL_NUM07 SQUAL_NUM07, SQUAL_NUM08 SQUAL_NUM08, SQUAL_NUM09 SQUAL_NUM09, SQUAL_NUM10 SQUAL_NUM10, SQUAL_NUM11 SQUAL_NUM11, SQUAL_NUM12 SQUAL_NUM12, SQUAL_NUM13 SQUAL_NUM13, SQUAL_NUM14 SQUAL_NUM14, SQUAL_NUM15 SQUAL_NUM15, SQUAL_NUM16 SQUAL_NUM16, SQUAL_NUM17 SQUAL_NUM17, SQUAL_NUM18 SQUAL_NUM18, SQUAL_NUM19 SQUAL_NUM19, SQUAL_NUM20 SQUAL_NUM20, SQUAL_NUM21 SQUAL_NUM21, SQUAL_NUM22 SQUAL_NUM22, SQUAL_NUM23 SQUAL_NUM23, SQUAL_NUM24 SQUAL_NUM24, SQUAL_NUM25 SQUAL_NUM25, SQUAL_NUM26 SQUAL_NUM26, SQUAL_NUM27 SQUAL_NUM27, SQUAL_NUM28 SQUAL_NUM28, SQUAL_NUM29 SQUAL_NUM29, SQUAL_NUM30 SQUAL_NUM30, SQUAL_NUM31 SQUAL_NUM31, SQUAL_NUM32 SQUAL_NUM32, SQUAL_NUM33 SQUAL_NUM33, SQUAL_NUM34 SQUAL_NUM34, SQUAL_NUM35 SQUAL_NUM35, SQUAL_NUM36 SQUAL_NUM36, SQUAL_NUM37 SQUAL_NUM37, SQUAL_NUM38 SQUAL_NUM38, SQUAL_NUM39 SQUAL_NUM39, SQUAL_NUM40 SQUAL_NUM40, SQUAL_NUM41 SQUAL_NUM41, SQUAL_NUM42 SQUAL_NUM42, SQUAL_NUM43 SQUAL_NUM43, SQUAL_NUM44 SQUAL_NUM44, SQUAL_NUM45 SQUAL_NUM45, SQUAL_NUM46 SQUAL_NUM46, SQUAL_NUM47 SQUAL_NUM47, SQUAL_NUM48 SQUAL_NUM48, SQUAL_NUM49 SQUAL_NUM49, SQUAL_NUM50 SQUAL_NUM50, SQUAL_NUM51 SQUAL_NUM51, SQUAL_NUM52 SQUAL_NUM52, SQUAL_NUM53 SQUAL_NUM53, SQUAL_NUM54 SQUAL_NUM54, SQUAL_NUM55 SQUAL_NUM55, SQUAL_NUM56 SQUAL_NUM56, SQUAL_NUM57 SQUAL_NUM57, SQUAL_NUM58 SQUAL_NUM58, SQUAL_NUM59 SQUAL_NUM59, SQUAL_NUM60 SQUAL_NUM60, ASSIGNED_FLAG ASSIGNED_FLAG, PROCESSED_FLAG PROCESSED_FLAG, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JTF"."JTF_TAE_RPT_OBJS"

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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SESSION_ID SESSION_ID
, SQUAL_FC01 SQUAL_FC01
, SQUAL_FC02 SQUAL_FC02
, SQUAL_FC03 SQUAL_FC03
, SQUAL_FC04 SQUAL_FC04
, SQUAL_FC05 SQUAL_FC05
, SQUAL_CURC01 SQUAL_CURC01
, SQUAL_CURC02 SQUAL_CURC02
, SQUAL_CURC03 SQUAL_CURC03
, SQUAL_CURC04 SQUAL_CURC04
, SQUAL_CURC05 SQUAL_CURC05
, SQUAL_CURC06 SQUAL_CURC06
, SQUAL_CURC07 SQUAL_CURC07
, SQUAL_CURC08 SQUAL_CURC08
, SQUAL_CURC09 SQUAL_CURC09
, SQUAL_CURC10 SQUAL_CURC10
, SQUAL_CHAR01 SQUAL_CHAR01
, SQUAL_CHAR02 SQUAL_CHAR02
, SQUAL_CHAR03 SQUAL_CHAR03
, SQUAL_CHAR04 SQUAL_CHAR04
, SQUAL_CHAR05 SQUAL_CHAR05
, SQUAL_CHAR06 SQUAL_CHAR06
, SQUAL_CHAR07 SQUAL_CHAR07
, SQUAL_CHAR08 SQUAL_CHAR08
, SQUAL_CHAR09 SQUAL_CHAR09
, SQUAL_CHAR10 SQUAL_CHAR10
, SQUAL_CHAR11 SQUAL_CHAR11
, SQUAL_CHAR12 SQUAL_CHAR12
, SQUAL_CHAR13 SQUAL_CHAR13
, SQUAL_CHAR14 SQUAL_CHAR14
, SQUAL_CHAR15 SQUAL_CHAR15
, SQUAL_CHAR16 SQUAL_CHAR16
, SQUAL_CHAR17 SQUAL_CHAR17
, SQUAL_CHAR18 SQUAL_CHAR18
, SQUAL_CHAR19 SQUAL_CHAR19
, SQUAL_CHAR20 SQUAL_CHAR20
, SQUAL_CHAR21 SQUAL_CHAR21
, SQUAL_CHAR22 SQUAL_CHAR22
, SQUAL_CHAR23 SQUAL_CHAR23
, SQUAL_CHAR24 SQUAL_CHAR24
, SQUAL_CHAR25 SQUAL_CHAR25
, SQUAL_CHAR26 SQUAL_CHAR26
, SQUAL_CHAR27 SQUAL_CHAR27
, SQUAL_CHAR28 SQUAL_CHAR28
, SQUAL_CHAR30 SQUAL_CHAR30
, SQUAL_CHAR31 SQUAL_CHAR31
, SQUAL_CHAR32 SQUAL_CHAR32
, SQUAL_CHAR33 SQUAL_CHAR33
, SQUAL_CHAR34 SQUAL_CHAR34
, SQUAL_CHAR35 SQUAL_CHAR35
, SQUAL_CHAR36 SQUAL_CHAR36
, SQUAL_CHAR37 SQUAL_CHAR37
, SQUAL_CHAR38 SQUAL_CHAR38
, SQUAL_CHAR39 SQUAL_CHAR39
, SQUAL_CHAR40 SQUAL_CHAR40
, SQUAL_CHAR41 SQUAL_CHAR41
, SQUAL_CHAR42 SQUAL_CHAR42
, SQUAL_CHAR43 SQUAL_CHAR43
, SQUAL_CHAR44 SQUAL_CHAR44
, SQUAL_CHAR45 SQUAL_CHAR45
, SQUAL_CHAR46 SQUAL_CHAR46
, SQUAL_CHAR47 SQUAL_CHAR47
, SQUAL_CHAR48 SQUAL_CHAR48
, SQUAL_CHAR49 SQUAL_CHAR49
, SQUAL_CHAR50 SQUAL_CHAR50
, SQUAL_CHAR51 SQUAL_CHAR51
, SQUAL_CHAR52 SQUAL_CHAR52
, SQUAL_CHAR53 SQUAL_CHAR53
, SQUAL_CHAR54 SQUAL_CHAR54
, SQUAL_CHAR55 SQUAL_CHAR55
, SQUAL_CHAR56 SQUAL_CHAR56
, SQUAL_CHAR57 SQUAL_CHAR57
, SQUAL_CHAR58 SQUAL_CHAR58
, SQUAL_CHAR59 SQUAL_CHAR59
, SQUAL_CHAR60 SQUAL_CHAR60
, SQUAL_NUM01 SQUAL_NUM01
, SQUAL_NUM02 SQUAL_NUM02
, SQUAL_NUM03 SQUAL_NUM03
, SQUAL_NUM04 SQUAL_NUM04
, SQUAL_NUM05 SQUAL_NUM05
, SQUAL_NUM06 SQUAL_NUM06
, SQUAL_NUM07 SQUAL_NUM07
, SQUAL_NUM08 SQUAL_NUM08
, SQUAL_NUM09 SQUAL_NUM09
, SQUAL_NUM10 SQUAL_NUM10
, SQUAL_NUM11 SQUAL_NUM11
, SQUAL_NUM12 SQUAL_NUM12
, SQUAL_NUM13 SQUAL_NUM13
, SQUAL_NUM14 SQUAL_NUM14
, SQUAL_NUM15 SQUAL_NUM15
, SQUAL_NUM16 SQUAL_NUM16
, SQUAL_NUM17 SQUAL_NUM17
, SQUAL_NUM18 SQUAL_NUM18
, SQUAL_NUM19 SQUAL_NUM19
, SQUAL_NUM20 SQUAL_NUM20
, SQUAL_NUM21 SQUAL_NUM21
, SQUAL_NUM22 SQUAL_NUM22
, SQUAL_NUM23 SQUAL_NUM23
, SQUAL_NUM24 SQUAL_NUM24
, SQUAL_NUM25 SQUAL_NUM25
, SQUAL_NUM26 SQUAL_NUM26
, SQUAL_NUM27 SQUAL_NUM27
, SQUAL_NUM28 SQUAL_NUM28
, SQUAL_NUM29 SQUAL_NUM29
, SQUAL_NUM30 SQUAL_NUM30
, SQUAL_NUM31 SQUAL_NUM31
, SQUAL_NUM32 SQUAL_NUM32
, SQUAL_NUM33 SQUAL_NUM33
, SQUAL_NUM34 SQUAL_NUM34
, SQUAL_NUM35 SQUAL_NUM35
, SQUAL_NUM36 SQUAL_NUM36
, SQUAL_NUM37 SQUAL_NUM37
, SQUAL_NUM38 SQUAL_NUM38
, SQUAL_NUM39 SQUAL_NUM39
, SQUAL_NUM40 SQUAL_NUM40
, SQUAL_NUM41 SQUAL_NUM41
, SQUAL_NUM42 SQUAL_NUM42
, SQUAL_NUM43 SQUAL_NUM43
, SQUAL_NUM44 SQUAL_NUM44
, SQUAL_NUM45 SQUAL_NUM45
, SQUAL_NUM46 SQUAL_NUM46
, SQUAL_NUM47 SQUAL_NUM47
, SQUAL_NUM48 SQUAL_NUM48
, SQUAL_NUM49 SQUAL_NUM49
, SQUAL_NUM50 SQUAL_NUM50
, SQUAL_NUM51 SQUAL_NUM51
, SQUAL_NUM52 SQUAL_NUM52
, SQUAL_NUM53 SQUAL_NUM53
, SQUAL_NUM54 SQUAL_NUM54
, SQUAL_NUM55 SQUAL_NUM55
, SQUAL_NUM56 SQUAL_NUM56
, SQUAL_NUM57 SQUAL_NUM57
, SQUAL_NUM58 SQUAL_NUM58
, SQUAL_NUM59 SQUAL_NUM59
, SQUAL_NUM60 SQUAL_NUM60
, ASSIGNED_FLAG ASSIGNED_FLAG
, PROCESSED_FLAG PROCESSED_FLAG
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JTF"."JTF_TAE_RPT_OBJS"