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

TABLE: JTF.JTF_TTY_GEO_WEBADI_INTERFACE

Object Details
Object Name: JTF_TTY_GEO_WEBADI_INTERFACE
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_TTY_GEO_WEBADI_INTERFACE
Subobject Name:
Status: VALID


Geography WEB ADI interface table


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
JTF_TTY_WEBADI_INT_ID NUMBER
Yes Web ADI Interface table Identifier
OBJECT_VERSION_NUMBER NUMBER
Yes standard column
USER_ID NUMBER
Yes User Identifier
USER_SEQUENCE NUMBER
Yes User sequence
TERRITORY_GROUP VARCHAR2 (150)
Territory Group
MANAGER_TERR_NAME VARCHAR2 (150)
Manager Territory Name
COUNTRY VARCHAR2 (80)
Country
STATE_PROVINCE VARCHAR2 (80)
State or Province
CITY VARCHAR2 (80)
City
POSTAL_CODE VARCHAR2 (80)
Postal Code
GEO_TERR_NAME VARCHAR2 (150)
Geography Territory Name
GEO_TERR_VALUE_ID NUMBER

Geography Territory Value Identifier
CREATED_BY NUMBER
Yes Created By
CREATION_DATE DATE
Yes Creation Date
LAST_UPDATED_BY NUMBER
Yes Last Updated By
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
Query Text

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


SELECT JTF_TTY_WEBADI_INT_ID
,      OBJECT_VERSION_NUMBER
,      USER_ID
,      USER_SEQUENCE
,      TERRITORY_GROUP
,      MANAGER_TERR_NAME
,      COUNTRY
,      STATE_PROVINCE
,      CITY
,      POSTAL_CODE
,      GEO_TERR_NAME
,      GEO_TERR_VALUE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM JTF.JTF_TTY_GEO_WEBADI_INTERFACE;

Dependencies

[top of page]

JTF.JTF_TTY_GEO_WEBADI_INTERFACE does not reference any database object

JTF.JTF_TTY_GEO_WEBADI_INTERFACE is referenced by following:

SchemaAPPS
SynonymJTF_TTY_GEO_WEBADI_INTERFACE