[Home] [Help] [Dependency Information]
Object Name: | PAY_LEGISLATIVE_FIELD_INFO |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_LEGISLATIVE_FIELD_INFO |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_LEGISLATIVE_FIELD_INFO_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
FIELD_NAME
LEGISLATION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FIELD_NAME | VARCHAR2 | (30) | Yes | The form field name affected |
LEGISLATION_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_TERRITORIES. |
PROMPT | VARCHAR2 | (30) | The name to display (not translated) | |
VALIDATION_NAME | VARCHAR2 | (30) | Name of validation to be applied | |
VALIDATION_TYPE | VARCHAR2 | (30) | Type of validation used. | |
TARGET_LOCATION | VARCHAR2 | (30) | Object, e.g. Form, for which the rule applies | |
RULE_TYPE | VARCHAR2 | (30) | Yes | Identifies the rule applied to the field |
RULE_MODE | VARCHAR2 | (30) | Status of the rule e.g. enabled or disabled | |
PROMPT_MESSAGE | VARCHAR2 | (30) | This will be the message which will be used for the Prompt text. | |
IN_LINE_MESSAGE | VARCHAR2 | (30) | This will be the message which will be used for the In-line Tip text. | |
QUICK_TIP_MESSAGE | VARCHAR2 | (30) | This will be the message which will be used for the Quick Tip text. | |
BUBBLE_TIP_MESSAGE | VARCHAR2 | (30) | This will be the message which will be used for the Bubble Tip text. | |
CATEGORY | VARCHAR2 | (30) | This will be the category in which the field will be grouped under.. |
Cut, paste (and edit) the following text to query this object:
SELECT FIELD_NAME
, LEGISLATION_CODE
, PROMPT
, VALIDATION_NAME
, VALIDATION_TYPE
, TARGET_LOCATION
, RULE_TYPE
, RULE_MODE
, PROMPT_MESSAGE
, IN_LINE_MESSAGE
, QUICK_TIP_MESSAGE
, BUBBLE_TIP_MESSAGE
, CATEGORY
FROM HR.PAY_LEGISLATIVE_FIELD_INFO;
HR.PAY_LEGISLATIVE_FIELD_INFO does not reference any database object
HR.PAY_LEGISLATIVE_FIELD_INFO is referenced by following:
|
|
|