[Home] [Help] [Dependency Information]
Object Name: | HR_TEMPLATE_ITEM_CONTEXTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HR_TEMPLATE_ITEM_CONTEXTS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID. | |
TEMPLATE_ITEM_CONTEXT_ID | NUMBER | (15) | Yes | System-generated primary key using sequence HR_TEMPLATE_ITEM_CONTEXTS_B_S. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | System-generated version of row. Increments by one with each update. |
TEMPLATE_ITEM_ID | NUMBER | (15) | Yes | Foreign Key to HR_TEMPLATE_ITEMS_B. |
CONTEXT_TYPE | VARCHAR2 | (30) | Yes | Type of context. Initially will be restricted to "Descriptive Flexfield" and "Key Flexfield". |
ITEM_CONTEXT_ID | NUMBER | (15) | Yes | Foreign Key to HR_ITEM_CONTEXTS. |
ALIGNMENT | NUMBER | (10) | Foreign Key to HR_ITEM_CONTEXTS. | |
BEVEL | NUMBER | (10) | The item border bevel. Valid values are RAISED, LOWERED or PLAIN. Applies to chart item, image item, custom item or text item. | |
CASE_RESTRICTION | NUMBER | (10) | Specifies the case restriction applied to any text entered in the indicated text item. Valid values are UPPERCASE, LOWERCASE, or NONE. Applies to text item. | |
DEFAULT_VALUE | VARCHAR2 | (2000) | Specifies the default value for the item. If for a number or date item it must be in the canonical format. | |
ENABLED | NUMBER | (10) | Specifies whether end users should be able to manipulate an item. Valid values are PROPERTY_TRUE and PROPERTY_FALSE. Does not apply to button, chart item or display item. | |
FORMAT_MASK | VARCHAR2 | (80) | Specifies the display format and input accepted. Applies to text item. | |
HEIGHT | NUMBER | (12) | Specifies the height of the item. | |
INFORMATION_FORMULA_ID | NUMBER | (15) | Foreign key to FF_FORMULAS.F_FORMULA_ID. Specifies the identifier of the formula to use to supply extra information about the item. The formula will return a text string which will be displayed to the user. Does not apply to button. | |
INFORMATION_PARAMETER_ITEM_ID1 | NUMBER | (15) | Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The second parameter to pass to the information formula. Applies only when an information formula has been specified. | |
INFORMATION_PARAMETER_ITEM_ID2 | NUMBER | (15) | Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The third parameter to pass to the information formula. Applies only when an information formula has been specified. | |
INFORMATION_PARAMETER_ITEM_ID3 | NUMBER | (15) | Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fourth parameter to pass to the information formula. Applies only when an information formula has been specified. | |
INFORMATION_PARAMETER_ITEM_ID4 | NUMBER | (15) | Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fifth parameter to pass to the information formula. Applies only when an information formula has been specified. | |
INFORMATION_PARAMETER_ITEM_ID5 | NUMBER | (15) | Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The sixth parameter to pass to the information formula. Applies only when an information formula has been specified. | |
INFORMATION_PROMPT | VARCHAR2 | (80) | Specifies the text to show in the popup-menu to initiate the information formula. Applies only when an information formula is specified. Must be given in this case. | |
INSERT_ALLOWED | NUMBER | (10) | In a new record, allows end user to insert items normally when set to PROPERTY_TRUE. Specify PROPERTY_FALSE to specify that the item does not accept modification, but is displayed normally. Applies to check box, custom item, image item, radio button, list item or text item. | |
LABEL | VARCHAR2 | (80) | Specifies the VARCHAR2 string that you want displayed as the label of the item. Applies to button, check box or radio group button. | |
PROMPT_ALIGNMENT_OFFSET | NUMBER | (12) | Determines the distance between the item and its prompt. | |
PROMPT_DISPLAY_STYLE | NUMBER | (10) | Determines the prompt's display style, either PROMPT_FIRST_RECORD, PROMPT_HIDDEN or PROMPT_ALL_RECORDS. | |
PROMPT_EDGE | NUMBER | (10) | Determines to which edge the prompt is attached. May be START_EDGE, END_EDGE, TOP_EDGE or BOTTOM_EDGE. | |
PROMPT_EDGE_ALIGNMENT | NUMBER | (10) | Determines to which edge the items prompt is aligned. May be ALIGNMENT_START, ALIGNMENT_END or ALIGNMENT_CENTER. | |
PROMPT_EDGE_OFFSET | NUMBER | (12) | Determines the distance between the item and its prompt. | |
PROMPT_TEXT | VARCHAR2 | (80) | Determines the text label that displays for an item. | |
PROMPT_TEXT_ALIGNMENT | NUMBER | (10) | Determines how the prompt is justified. May be ALIGNMENT_START, ALIGNMENT_LEFT, ALIGNMENT_RIGHT, ALIGNMENT_CENTER or ALIGNMENT_END. | |
QUERY_ALLOWED | NUMBER | (10) | Specify the constant PROPERTY_TRUE if you want the end user to be able to initiate a query against the item. Specify the constant PROPERTY_FALSE if you want to disallow the use of the item in a query. Does not apply to button, chart item or image item. | |
REQUIRED | NUMBER | (10) | Specify the constant PROPERTY_TRUE if you want to force the end user to enter a value for the item. Specify the constant PROPERTY_FALSE if the item is not to be required. Applies to list item or text item. | |
TOOLTIP_TEXT | VARCHAR2 | (80) | Determines the ballon text for an item | |
UPDATE_ALLOWED | NUMBER | (10) | Specify the constant PROPERTY_TRUE if you want the end user to be able to update the item. Specify the constant PROPERTY_FALSE if you want the item protected from update. Does not apply to button, chart item or image item. | |
VALIDATION_FORMULA_ID | NUMBER | (15) | Foreign key to FF_FORMULAS_F.FORMULA_ID. Specifies the identifier of the formula to use to augment the default validation of the item. This first parameter to the formula will always be the item it is associated with. Does not apply to button, chart item or image item. | |
VALIDATION_PARAMETER_ITEM_ID1 | NUMBER | (15) | Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The second parameter to pass to the validation formula. Applies only when a validation formula has been specified. | |
VALIDATION_PARAMETER_ITEM_ID2 | NUMBER | (15) | Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The third parameter to pass to the validation formula. Applies only when a validation formula has been specified. | |
VALIDATION_PARAMETER_ITEM_ID3 | NUMBER | (15) | Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fourth parameter to pass to the validation formula. Applies only when a validation formula has been specified. | |
VALIDATION_PARAMETER_ITEM_ID4 | NUMBER | (15) | Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fifth parameter to pass to the validation formula. Applies only when a validation formula has been specified. | |
VALIDATION_PARAMETER_ITEM_ID5 | NUMBER | (15) | Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The sixth parameter to pass to the validation formula. Applies only when a validation formula has been specified. | |
VISIBLE | NUMBER | (10) | Specifies whether the indicated item should be visible or hidden. Valid values are PROPERTY_TRUE and PROPERTY_FALSE. | |
WIDTH | NUMBER | (12) | Specifies the width of the item. | |
X_POSITION | NUMBER | (12) | Specifies the x coordinate of the item. | |
Y_POSITION | NUMBER | (12) | Specifies the y coordinate of the item. | |
INFORMATION_CATEGORY | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION1 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION2 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION3 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION4 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION5 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION6 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION7 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION8 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION9 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION10 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION11 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION12 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION13 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION14 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION15 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION16 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION17 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION18 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION19 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION20 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION21 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION22 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION23 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION24 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION25 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION26 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION27 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION28 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION29 | VARCHAR2 | (150) | Developer Descriptive Flexfield column. | |
INFORMATION30 | VARCHAR2 | (150) | Developer Descriptive Flexfield 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. | ||
NEXT_NAVIGATION_ITEM_ID | NUMBER | (15) | Foreign key to HR_TEMPLATE_ITEMS_B. | |
PREVIOUS_NAVIGATION_ITEM_ID | NUMBER | (15) | Foreign key to HR_TEMPLATE_ITEMS_B. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TEMPLATE_ITEM_CONTEXT_ID
, OBJECT_VERSION_NUMBER
, TEMPLATE_ITEM_ID
, CONTEXT_TYPE
, ITEM_CONTEXT_ID
, ALIGNMENT
, BEVEL
, CASE_RESTRICTION
, DEFAULT_VALUE
, ENABLED
, FORMAT_MASK
, HEIGHT
, INFORMATION_FORMULA_ID
, INFORMATION_PARAMETER_ITEM_ID1
, INFORMATION_PARAMETER_ITEM_ID2
, INFORMATION_PARAMETER_ITEM_ID3
, INFORMATION_PARAMETER_ITEM_ID4
, INFORMATION_PARAMETER_ITEM_ID5
, INFORMATION_PROMPT
, INSERT_ALLOWED
, LABEL
, PROMPT_ALIGNMENT_OFFSET
, PROMPT_DISPLAY_STYLE
, PROMPT_EDGE
, PROMPT_EDGE_ALIGNMENT
, PROMPT_EDGE_OFFSET
, PROMPT_TEXT
, PROMPT_TEXT_ALIGNMENT
, QUERY_ALLOWED
, REQUIRED
, TOOLTIP_TEXT
, UPDATE_ALLOWED
, VALIDATION_FORMULA_ID
, VALIDATION_PARAMETER_ITEM_ID1
, VALIDATION_PARAMETER_ITEM_ID2
, VALIDATION_PARAMETER_ITEM_ID3
, VALIDATION_PARAMETER_ITEM_ID4
, VALIDATION_PARAMETER_ITEM_ID5
, VISIBLE
, WIDTH
, X_POSITION
, Y_POSITION
, INFORMATION_CATEGORY
, INFORMATION1
, INFORMATION2
, INFORMATION3
, INFORMATION4
, INFORMATION5
, INFORMATION6
, INFORMATION7
, INFORMATION8
, INFORMATION9
, INFORMATION10
, INFORMATION11
, INFORMATION12
, INFORMATION13
, INFORMATION14
, INFORMATION15
, INFORMATION16
, INFORMATION17
, INFORMATION18
, INFORMATION19
, INFORMATION20
, INFORMATION21
, INFORMATION22
, INFORMATION23
, INFORMATION24
, INFORMATION25
, INFORMATION26
, INFORMATION27
, INFORMATION28
, INFORMATION29
, INFORMATION30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, NEXT_NAVIGATION_ITEM_ID
, PREVIOUS_NAVIGATION_ITEM_ID
FROM APPS.HR_TEMPLATE_ITEM_CONTEXTS;
|
|
|