[Home] [Help] [Dependency Information]
Object Name: | JTY_CHANGED_TERRS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTY_CHANGED_TERRS |
Subobject Name: | |
Status: | VALID |
This table stores changed territories.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTY_CHANGED_TERRS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TERR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANGED_TERRITORY_ID | NUMBER | Yes | Primary key | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number | |
TERR_ID | NUMBER | Foreign key to JTF_TERR_ALL | ||
SOURCE_ID | NUMBER | Source ID | ||
CHANGE_TYPE | VARCHAR2 | (80) | Change type | |
RANK_CALC_FLAG | VARCHAR2 | (1) | Rank calculation flag | |
PROCESS_ATTR_VALUES_FLAG | VARCHAR2 | (1) | Process attribute values flag | |
MATCHING_SQL_FLAG | VARCHAR2 | (1) | Matching SQL flag | |
HIER_PROCESSING_FLAG | VARCHAR2 | (1) | Hierarchy processing flag | |
STAR_REQUEST_ID | NUMBER | STAR request_id | ||
TAP_REQUEST_ID | NUMBER | TAP request_id |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGED_TERRITORY_ID
, OBJECT_VERSION_NUMBER
, TERR_ID
, SOURCE_ID
, CHANGE_TYPE
, RANK_CALC_FLAG
, PROCESS_ATTR_VALUES_FLAG
, MATCHING_SQL_FLAG
, HIER_PROCESSING_FLAG
, STAR_REQUEST_ID
, TAP_REQUEST_ID
FROM JTF.JTY_CHANGED_TERRS;
JTF.JTY_CHANGED_TERRS does not reference any database object
JTF.JTY_CHANGED_TERRS is referenced by following:
|
|
|