[Home] [Help] [Dependency Information]
Object Name: | PQP_CONFIGURATION_TYPES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PQP.PQP_CONFIGURATION_TYPES |
Subobject Name: | |
Status: | VALID |
Entity used to store the information types (configuration types) for each module stored in pqp_configuration_modules. Each row identifies one configuration type and the values for this type is stored in pqp_configuration_values table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQP_CONFIGURATION_TYPES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CONFIGURATION_TYPE
MODULE_ID LEGISLATION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONFIGURATION_TYPE | VARCHAR2 | (40) | Yes | The name of the configuration type for a particular module. |
MODULE_ID | NUMBER | (15) | Yes | Identifies the module for the configuration type. Foreign key to pqp_configuration_modules table. |
ACTIVE_INACTIVE_FLAG | VARCHAR2 | (30) | Yes | Identifies whether the configuration type is active. The valid values are 'A' and 'I'. |
DESCRIPTION | VARCHAR2 | (240) | Description of the configuration type. | |
MULTIPLE_OCCURENCES_FLAG | VARCHAR2 | (30) | Yes | Identifies whether multiple rows are allowed for this configuration type. |
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation code of the configuration type. | |
TOTAL_UNIQUE_COLUMNS | NUMBER | (9) | Identifies the number of PCV_INFORMATION columns starting from 1 that are unique for this configuration. This is used to validate the data, as the uniqueness is different for each configuration type. | |
PROTECTED_FLAG | VARCHAR2 | (30) | Identifies whether the seeded data in the Confuguration Values table is protected from user updates. If the value is 'N', the users are allowed to update the seeded values. If the value is 'Y', users will be able to create a new row for the business group. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent program application id. | |
PROGRAM_ID | NUMBER | (15) | Concurrent program id. | |
REQUEST_ID | NUMBER | (15) | Concurrent program request id. | |
PROGRAM_UPDATE_DATE | DATE | Concurrent program update date. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | 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 CONFIGURATION_TYPE
, MODULE_ID
, ACTIVE_INACTIVE_FLAG
, DESCRIPTION
, MULTIPLE_OCCURENCES_FLAG
, LEGISLATION_CODE
, TOTAL_UNIQUE_COLUMNS
, PROTECTED_FLAG
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, REQUEST_ID
, PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PQP_CONFIGURATION_TYPES;
HR.PQP_CONFIGURATION_TYPES does not reference any database object
HR.PQP_CONFIGURATION_TYPES is referenced by following:
|
|
|