[Home] [Help] [Dependency Information]
Object Name: | FTE_PTRK_SOURCES |
---|---|
Object Type: | TABLE |
Owner: | FTE |
FND Design Data: | FTE.FTE_PTRK_SOURCES |
Subobject Name: | |
Status: | VALID |
Table to store tracking type information
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FTE_PTRK_SOURCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OWNER_APPLICATION_ID
TOKEN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER_APPLICATION_ID | NUMBER | (15) | Yes | Owner application id |
TOKEN_ID | NUMBER | (15) | Yes | Token id |
TOKEN_NAME | VARCHAR2 | (150) | Yes | Token name |
PAGE_GRANULARITY | VARCHAR2 | (20) | Yes | Page granularity |
SOURCE_TABLE | VARCHAR2 | (50) | Yes | Source table name |
SOURCE_COLUMN | VARCHAR2 | (50) | Yes | Source column name |
KEY_COLUMN1 | VARCHAR2 | (50) | Yes | Key column 1 |
KEY_COLUMN2 | VARCHAR2 | (50) | Key column 2 | |
KEY_COLUMN3 | VARCHAR2 | (50) | Key column 3 | |
KEY_COLUMN4 | VARCHAR2 | (50) | Key column 4 | |
KEY_COLUMN5 | VARCHAR2 | (50) | Key column 5 | |
CREATED_BY | NUMBER | Yes | Standard who columns | |
CREATION_DATE | DATE | Yes | Standard who columns | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who columns | |
LAST_UPDATE_DATE | DATE | Yes | Standard who columns | |
LAST_UPDATE_LOGIN | NUMBER | Standard who columns |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER_APPLICATION_ID
, TOKEN_ID
, TOKEN_NAME
, PAGE_GRANULARITY
, SOURCE_TABLE
, SOURCE_COLUMN
, KEY_COLUMN1
, KEY_COLUMN2
, KEY_COLUMN3
, KEY_COLUMN4
, KEY_COLUMN5
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM FTE.FTE_PTRK_SOURCES;
FTE.FTE_PTRK_SOURCES does not reference any database object
FTE.FTE_PTRK_SOURCES is referenced by following:
|
|
|