eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: JTF.JTF_TAE_RPT_OBJS#

Object Details

Object Name:	JTF_TAE_RPT_OBJS#
Object Type:	VIEW
Owner:	JTF
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TRANS_OBJECT_ID	NUMBER		Yes
TRANS_DETAIL_OBJECT_ID	NUMBER
HEADER_ID1	NUMBER
HEADER_ID2	NUMBER
SOURCE_ID	NUMBER		Yes
TRANS_OBJECT_TYPE_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
SESSION_ID	NUMBER		Yes
SQUAL_FC01	VARCHAR2	(3)
SQUAL_FC02	VARCHAR2	(3)
SQUAL_FC03	VARCHAR2	(3)
SQUAL_FC04	VARCHAR2	(3)
SQUAL_FC05	VARCHAR2	(3)
SQUAL_CURC01	VARCHAR2	(30)
SQUAL_CURC02	VARCHAR2	(30)
SQUAL_CURC03	VARCHAR2	(30)
SQUAL_CURC04	VARCHAR2	(30)
SQUAL_CURC05	VARCHAR2	(30)
SQUAL_CURC06	VARCHAR2	(30)
SQUAL_CURC07	VARCHAR2	(30)
SQUAL_CURC08	VARCHAR2	(30)
SQUAL_CURC09	VARCHAR2	(30)
SQUAL_CURC10	VARCHAR2	(30)
SQUAL_CHAR01	VARCHAR2	(360)
SQUAL_CHAR02	VARCHAR2	(360)
SQUAL_CHAR03	VARCHAR2	(360)
SQUAL_CHAR04	VARCHAR2	(360)
SQUAL_CHAR05	VARCHAR2	(360)
SQUAL_CHAR06	VARCHAR2	(360)
SQUAL_CHAR07	VARCHAR2	(360)
SQUAL_CHAR08	VARCHAR2	(360)
SQUAL_CHAR09	VARCHAR2	(360)
SQUAL_CHAR10	VARCHAR2	(360)
SQUAL_CHAR11	VARCHAR2	(240)
SQUAL_CHAR12	VARCHAR2	(240)
SQUAL_CHAR13	VARCHAR2	(240)
SQUAL_CHAR14	VARCHAR2	(240)
SQUAL_CHAR15	VARCHAR2	(240)
SQUAL_CHAR16	VARCHAR2	(240)
SQUAL_CHAR17	VARCHAR2	(240)
SQUAL_CHAR18	VARCHAR2	(240)
SQUAL_CHAR19	VARCHAR2	(240)
SQUAL_CHAR20	VARCHAR2	(240)
SQUAL_CHAR21	VARCHAR2	(360)
SQUAL_CHAR22	VARCHAR2	(360)
SQUAL_CHAR23	VARCHAR2	(360)
SQUAL_CHAR24	VARCHAR2	(360)
SQUAL_CHAR25	VARCHAR2	(360)
SQUAL_CHAR26	VARCHAR2	(360)
SQUAL_CHAR27	VARCHAR2	(360)
SQUAL_CHAR28	VARCHAR2	(360)
SQUAL_CHAR30	VARCHAR2	(360)
SQUAL_CHAR31	VARCHAR2	(360)
SQUAL_CHAR32	VARCHAR2	(360)
SQUAL_CHAR33	VARCHAR2	(360)
SQUAL_CHAR34	VARCHAR2	(360)
SQUAL_CHAR35	VARCHAR2	(360)
SQUAL_CHAR36	VARCHAR2	(360)
SQUAL_CHAR37	VARCHAR2	(360)
SQUAL_CHAR38	VARCHAR2	(360)
SQUAL_CHAR39	VARCHAR2	(360)
SQUAL_CHAR40	VARCHAR2	(360)
SQUAL_CHAR41	VARCHAR2	(360)
SQUAL_CHAR42	VARCHAR2	(360)
SQUAL_CHAR43	VARCHAR2	(360)
SQUAL_CHAR44	VARCHAR2	(360)
SQUAL_CHAR45	VARCHAR2	(360)
SQUAL_CHAR46	VARCHAR2	(360)
SQUAL_CHAR47	VARCHAR2	(360)
SQUAL_CHAR48	VARCHAR2	(360)
SQUAL_CHAR49	VARCHAR2	(360)
SQUAL_CHAR50	VARCHAR2	(360)
SQUAL_CHAR51	VARCHAR2	(360)
SQUAL_CHAR52	VARCHAR2	(360)
SQUAL_CHAR53	VARCHAR2	(360)
SQUAL_CHAR54	VARCHAR2	(360)
SQUAL_CHAR55	VARCHAR2	(360)
SQUAL_CHAR56	VARCHAR2	(360)
SQUAL_CHAR57	VARCHAR2	(360)
SQUAL_CHAR58	VARCHAR2	(360)
SQUAL_CHAR59	VARCHAR2	(360)
SQUAL_CHAR60	VARCHAR2	(360)
SQUAL_NUM01	NUMBER
SQUAL_NUM02	NUMBER
SQUAL_NUM03	NUMBER
SQUAL_NUM04	NUMBER
SQUAL_NUM05	NUMBER
SQUAL_NUM06	NUMBER
SQUAL_NUM07	NUMBER
SQUAL_NUM08	NUMBER
SQUAL_NUM09	NUMBER
SQUAL_NUM10	NUMBER
SQUAL_NUM11	NUMBER
SQUAL_NUM12	NUMBER
SQUAL_NUM13	NUMBER
SQUAL_NUM14	NUMBER
SQUAL_NUM15	NUMBER
SQUAL_NUM16	NUMBER
SQUAL_NUM17	NUMBER
SQUAL_NUM18	NUMBER
SQUAL_NUM19	NUMBER
SQUAL_NUM20	NUMBER
SQUAL_NUM21	NUMBER
SQUAL_NUM22	NUMBER
SQUAL_NUM23	NUMBER
SQUAL_NUM24	NUMBER
SQUAL_NUM25	NUMBER
SQUAL_NUM26	NUMBER
SQUAL_NUM27	NUMBER
SQUAL_NUM28	NUMBER
SQUAL_NUM29	NUMBER
SQUAL_NUM30	NUMBER
SQUAL_NUM31	NUMBER
SQUAL_NUM32	NUMBER
SQUAL_NUM33	NUMBER
SQUAL_NUM34	NUMBER
SQUAL_NUM35	NUMBER
SQUAL_NUM36	NUMBER
SQUAL_NUM37	NUMBER
SQUAL_NUM38	NUMBER
SQUAL_NUM39	NUMBER
SQUAL_NUM40	NUMBER
SQUAL_NUM41	NUMBER
SQUAL_NUM42	NUMBER
SQUAL_NUM43	NUMBER
SQUAL_NUM44	NUMBER
SQUAL_NUM45	NUMBER
SQUAL_NUM46	NUMBER
SQUAL_NUM47	NUMBER
SQUAL_NUM48	NUMBER
SQUAL_NUM49	NUMBER
SQUAL_NUM50	NUMBER
SQUAL_NUM51	NUMBER
SQUAL_NUM52	NUMBER
SQUAL_NUM53	NUMBER
SQUAL_NUM54	NUMBER
SQUAL_NUM55	NUMBER
SQUAL_NUM56	NUMBER
SQUAL_NUM57	NUMBER
SQUAL_NUM58	NUMBER
SQUAL_NUM59	NUMBER
SQUAL_NUM60	NUMBER
ASSIGNED_FLAG	VARCHAR2	(3)
PROCESSED_FLAG	VARCHAR2	(3)
ORG_ID	NUMBER
SECURITY_GROUP_ID	NUMBER
OBJECT_VERSION_NUMBER	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

JTF.JTF_TAE_RPT_OBJS# references the following:

JTF: JTF_TAE_RPT_OBJS

JTF.JTF_TAE_RPT_OBJS# is referenced by following:

APPS: JTF_TAE_RPT_OBJS