[Home] [Help] [Dependency Information]
Object Name: | PQP_CONFIGURATION_MODULES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PQP.PQP_CONFIGURATION_MODULES |
Subobject Name: | |
Status: | VALID |
Table used to keep track of modules that has configuration values setup. This is used in the UI to identify only configurations that are relevant for that legislation or product.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQP_CONFIGURATION_MODULES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | MODULE_ID |
PQP_CONFIGURATION_MODULES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MODULE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MODULE_ID | NUMBER | (15) | Yes | Generated primary key. |
MODULE_NAME | VARCHAR2 | (150) | Yes | The module name for which configuration types and values will be created. |
BUSINESS_GROUP_ID | NUMBER | (10) | Foreign key to HR_ORGANIZATION_UNITS. | |
LEGISLATION_CODE | VARCHAR2 | (30) | The legislation to which this module belongs. | |
DESCRIPTION | VARCHAR2 | (240) | Description of the module for which configuration values will be created. | |
APPLICATION_ID | NUMBER | (15) | Yes | Identifies the application of the configuration module. Foreign key to FND_APPLICATION table. |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Standard WHO column. |
LAST_UPDATE_DATE | DATE | Standard WHO column. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard WHO column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column. | |
CREATED_BY | NUMBER | (15) | Standard WHO column. | |
CREATION_DATE | DATE | Standard WHO column. |
Cut, paste (and edit) the following text to query this object:
SELECT MODULE_ID
, MODULE_NAME
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, DESCRIPTION
, APPLICATION_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PQP_CONFIGURATION_MODULES;
HR.PQP_CONFIGURATION_MODULES does not reference any database object
HR.PQP_CONFIGURATION_MODULES is referenced by following:
|
|
|