[Home] [Help] [Dependency Information]
Object Name: | JAI_RGM_TERM_ASSIGNS |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_RGM_TERM_ASSIGNS |
Subobject Name: | |
Status: | VALID |
Stores the term assignments to default at various hierarchial levels regime/ registration no/organization/location
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_RGM_TERM_ASSIGNS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | TERM_ASSIGNMENT_ID |
JAI_RGM_TERM_ASSIGNS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
REGIME_ID
REGIME_ITEM_CLASS REGIME_REGNO ORGANIZATION_ID ORGANIZATION_TYPE LOCATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TERM_ASSIGNMENT_ID | NUMBER | Yes | Stores unique term assignment identifier | |
TERM_ID | NUMBER | Yes | Stores term identifier which is applicable to the assignment | |
REGIME_ID | NUMBER | Stores regime identifier of regime defined | ||
REGIME_ITEM_CLASS | VARCHAR2 | (50) | Stores regime item class | |
REGIME_REGNO | VARCHAR2 | (240) | Stores the regime "primary" registration number | |
ORGANIZATION_ID | NUMBER | Stores the organization identifier | ||
ORGANIZATION_TYPE | VARCHAR2 | (3) | Stores the organization type "OU" or "IO" | |
LOCATION_ID | NUMBER | Stores the location identifier for specified organization | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object Version Number. |
Cut, paste (and edit) the following text to query this object:
SELECT TERM_ASSIGNMENT_ID
, TERM_ID
, REGIME_ID
, REGIME_ITEM_CLASS
, REGIME_REGNO
, ORGANIZATION_ID
, ORGANIZATION_TYPE
, LOCATION_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, OBJECT_VERSION_NUMBER
FROM JA.JAI_RGM_TERM_ASSIGNS;
JA.JAI_RGM_TERM_ASSIGNS does not reference any database object
JA.JAI_RGM_TERM_ASSIGNS is referenced by following:
|
|
|