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

TABLE: JTF.JTF_TTY_NAMED_ACCT_CHANGES

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


This table stores the changes in the self service territory groups.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
NAMED_ACCT_CHANGE_ID NUMBER
Yes Unique identifier generated from sequence.
OBJECT_VERSION_NUMBER NUMBER
Yes Standard Column
OBJECT_TYPE VARCHAR2 (80)
Determines the type of the object , like territory group or territory group account or geography territory or named account .
OBJECT_ID NUMBER

Foreign key to the master table of the object .
CHANGE_TYPE VARCHAR2 (30)
Type of change , like , DELETE or INSERT .
FROM_WHERE VARCHAR2 (80)
Identifies the place from this change took place.
CREATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
Query Text

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


SELECT NAMED_ACCT_CHANGE_ID
,      OBJECT_VERSION_NUMBER
,      OBJECT_TYPE
,      OBJECT_ID
,      CHANGE_TYPE
,      FROM_WHERE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM JTF.JTF_TTY_NAMED_ACCT_CHANGES;

Dependencies

[top of page]

JTF.JTF_TTY_NAMED_ACCT_CHANGES does not reference any database object

JTF.JTF_TTY_NAMED_ACCT_CHANGES is referenced by following:

SchemaAPPS
SynonymJTF_TTY_NAMED_ACCT_CHANGES