[Home] [Help] [Dependency Information]
Object Name: | PAY_FUNCTIONAL_AREAS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_FUNCTIONAL_AREAS |
Subobject Name: | |
Status: | VALID |
PAY_FUNCTIONAL_AREAS a description of the different functional areas
into which triggers (or rather, the event definitions from which triggers
are dynamically generated) can be grouped. This information will be
probably be seeded and the end users will not be given access to maintain it.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_FUNCTIONAL_AREAS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | AREA_ID |
Table | |
Foreign Table | Foreign Key Column | PAY_FUNCTIONAL_TRIGGERS | PAY_FUNCTIONAL_AREAS | PAY_FUNCTIONAL_TRIGGERS AREA_ID | PAY_FUNCTIONAL_USAGES | PAY_FUNCTIONAL_AREAS | PAY_FUNCTIONAL_USAGES AREA_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AREA_ID | NUMBER | (15) | Yes | System-generated primary key column. |
SHORT_NAME | VARCHAR2 | (60) | Yes | Short user identifying name |
DESCRIPTION | VARCHAR2 | (240) | More descriptive version of short name | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. |
Cut, paste (and edit) the following text to query this object:
SELECT AREA_ID
, SHORT_NAME
, DESCRIPTION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PAY_FUNCTIONAL_AREAS;
HR.PAY_FUNCTIONAL_AREAS does not reference any database object
HR.PAY_FUNCTIONAL_AREAS is referenced by following:
|
|
|