[Home] [Help] [Dependency Information]
Object Name: | JTF_TAE_RPT_STAGING_OUT# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANS_OBJECT_ID | NUMBER | Yes | ||
TRANS_DETAIL_OBJECT_ID | NUMBER | Yes | ||
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 | |||
SESSION_ID | NUMBER | Yes | ||
AT_CHAR01 | VARCHAR2 | (240) | ||
AT_CHAR02 | VARCHAR2 | (240) | ||
AT_CHAR03 | VARCHAR2 | (240) | ||
AT_CHAR04 | VARCHAR2 | (240) | ||
AT_CHAR05 | VARCHAR2 | (240) | ||
AT_CHAR06 | VARCHAR2 | (240) | ||
AT_CHAR07 | VARCHAR2 | (240) | ||
AT_CHAR08 | VARCHAR2 | (240) | ||
AT_CHAR09 | VARCHAR2 | (240) | ||
AT_CHAR10 | VARCHAR2 | (240) | ||
AT_CHAR11 | VARCHAR2 | (240) | ||
AT_CHAR12 | VARCHAR2 | (240) | ||
AT_CHAR13 | VARCHAR2 | (240) | ||
AT_CHAR14 | VARCHAR2 | (240) | ||
AT_CHAR15 | VARCHAR2 | (240) | ||
AT_CHAR16 | VARCHAR2 | (240) | ||
AT_CHAR17 | VARCHAR2 | (240) | ||
AT_CHAR18 | VARCHAR2 | (240) | ||
AT_CHAR19 | VARCHAR2 | (240) | ||
AT_CHAR20 | VARCHAR2 | (240) | ||
AT_NUM01 | NUMBER | |||
AT_NUM02 | NUMBER | |||
AT_NUM03 | NUMBER | |||
AT_NUM04 | NUMBER | |||
AT_NUM05 | NUMBER | |||
AT_NUM06 | NUMBER | |||
AT_NUM07 | NUMBER | |||
AT_NUM08 | NUMBER | |||
AT_NUM09 | NUMBER | |||
AT_NUM10 | NUMBER | |||
AT_NUM11 | NUMBER | |||
AT_NUM12 | NUMBER | |||
AT_NUM13 | NUMBER | |||
AT_NUM14 | NUMBER | |||
AT_NUM15 | NUMBER | |||
AT_NUM16 | NUMBER | |||
AT_NUM17 | NUMBER | |||
AT_NUM18 | NUMBER | |||
AT_NUM19 | NUMBER | |||
AT_NUM20 | NUMBER | |||
TERR_ID | NUMBER | Yes | ||
TERR_NAME | VARCHAR2 | (240) | ||
TERR_RANK | NUMBER | |||
RELATED_TERR_ID | NUMBER | |||
RELATED_TERR_NAME | VARCHAR2 | (240) | ||
RESOURCE_ID | NUMBER | |||
RESOURCE_TYPE | VARCHAR2 | (240) | ||
PERSON_ID | NUMBER | |||
RESOURCE_NAME | VARCHAR2 | (240) | ||
GROUP_ID | NUMBER | |||
GROUP_NAME | VARCHAR2 | (240) | ||
ROLE | VARCHAR2 | (240) | ||
ROLE_NAME | VARCHAR2 | (240) | ||
TERR_QUAL_ID | NUMBER | |||
QUAL_USG_ID | NUMBER | |||
QUALIFIER_NAME | VARCHAR2 | (240) | ||
TERR_VALUE_ID | NUMBER | |||
LOW_VALUE_CHAR | VARCHAR2 | (240) | ||
HIGH_VALUE_CHAR | VARCHAR2 | (240) | ||
ORG_ID | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER |
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
, SESSION_ID
, AT_CHAR01
, AT_CHAR02
, AT_CHAR03
, AT_CHAR04
, AT_CHAR05
, AT_CHAR06
, AT_CHAR07
, AT_CHAR08
, AT_CHAR09
, AT_CHAR10
, AT_CHAR11
, AT_CHAR12
, AT_CHAR13
, AT_CHAR14
, AT_CHAR15
, AT_CHAR16
, AT_CHAR17
, AT_CHAR18
, AT_CHAR19
, AT_CHAR20
, AT_NUM01
, AT_NUM02
, AT_NUM03
, AT_NUM04
, AT_NUM05
, AT_NUM06
, AT_NUM07
, AT_NUM08
, AT_NUM09
, AT_NUM10
, AT_NUM11
, AT_NUM12
, AT_NUM13
, AT_NUM14
, AT_NUM15
, AT_NUM16
, AT_NUM17
, AT_NUM18
, AT_NUM19
, AT_NUM20
, TERR_ID
, TERR_NAME
, TERR_RANK
, RELATED_TERR_ID
, RELATED_TERR_NAME
, RESOURCE_ID
, RESOURCE_TYPE
, PERSON_ID
, RESOURCE_NAME
, GROUP_ID
, GROUP_NAME
, ROLE
, ROLE_NAME
, TERR_QUAL_ID
, QUAL_USG_ID
, QUALIFIER_NAME
, TERR_VALUE_ID
, LOW_VALUE_CHAR
, HIGH_VALUE_CHAR
, ORG_ID
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM JTF.JTF_TAE_RPT_STAGING_OUT#;
|
|
|