[Home] [Help] [Dependency Information]
Object Name: | PQH_TEMPLATES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PQH.PQH_TEMPLATES |
Subobject Name: | |
Status: | VALID |
TEMPLATE along with TEMPLATE_ATTRIBUTES defines which attributes can be changed / viewed. It can be considered as a transparency, which is overlayed on a transaction form. Each transaction can have one or more templates applied to a transaction. Template can also be understood as a type of transaction like "Reclassify Position".
Each user will also have a "system" defined template, which will determine the maximum rights of an user. Based on this template other template determine which attributes can be opened for change / view.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQH_TEMPLATES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | TEMPLATE_ID |
PQH_TEMPLATES_UK | NORMAL | UNIQUE | APPS_TS_TX_IDX | SHORT_NAME |
PQH_TEMPLATES_FK | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_CATEGORY_ID |
Table | |
Foreign Table | Foreign Key Column | PQH_TEMPLATES | PQH_TRANSACTION_CATEGORIES | PQH_TEMPLATES TRANSACTION_CATEGORY_ID | PQH_REF_TEMPLATES | PQH_TEMPLATES | PQH_REF_TEMPLATES PARENT_TEMPLATE_ID | PQH_REF_TEMPLATES | PQH_TEMPLATES | PQH_REF_TEMPLATES BASE_TEMPLATE_ID | PQH_ROLE_TEMPLATES | PQH_TEMPLATES | PQH_ROLE_TEMPLATES TEMPLATE_ID | PQH_TEMPLATE_ATTRIBUTES | PQH_TEMPLATES | PQH_TEMPLATE_ATTRIBUTES TEMPLATE_ID | PQH_TRANSACTION_TEMPLATES | PQH_TEMPLATES | PQH_TRANSACTION_TEMPLATES TEMPLATE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | (15) | Yes | Primary Key |
TEMPLATE_NAME | VARCHAR2 | (100) | Yes | Template Description |
SHORT_NAME | VARCHAR2 | (30) | Yes | Developer Key |
ATTRIBUTE_ONLY_FLAG | VARCHAR2 | (10) | identifies if this template can reference other templates | |
ENABLE_FLAG | VARCHAR2 | (10) | Yes | Enabled / disabled |
CREATE_FLAG | VARCHAR2 | (10) | identifies if a template is create or update (for task template) | |
TRANSACTION_CATEGORY_ID | NUMBER | (15) | Yes | Transaction category identifier |
UNDER_REVIEW_FLAG | VARCHAR2 | (10) | Indicates if a transaction is to placed under review (for update template only) | |
FREEZE_STATUS_CD | VARCHAR2 | (30) | Frozed or not | |
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) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version Number |
TEMPLATE_TYPE_CD | VARCHAR2 | (30) | Yes | Role template / task template |
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation Code |
Cut, paste (and edit) the following text to query this object:
SELECT TEMPLATE_ID
, TEMPLATE_NAME
, SHORT_NAME
, ATTRIBUTE_ONLY_FLAG
, ENABLE_FLAG
, CREATE_FLAG
, TRANSACTION_CATEGORY_ID
, UNDER_REVIEW_FLAG
, FREEZE_STATUS_CD
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, TEMPLATE_TYPE_CD
, LEGISLATION_CODE
FROM HR.PQH_TEMPLATES;
HR.PQH_TEMPLATES does not reference any database object
HR.PQH_TEMPLATES is referenced by following:
|
|
|