Product: | PER - Human Resources |
---|---|
Description: | Translated view of HR_ITEM_PROPERTIES_B and HR_ITEM_PROPERTIES_TL |
Implementation/DBA Data: | APPS.HR_ITEM_PROPERTIES_VL |
SELECT B.ROWID
, B.ITEM_PROPERTY_ID
, B.FORM_ITEM_ID
, B.TEMPLATE_ITEM_ID
, B.TEMPLATE_ITEM_CONTEXT_ID
, B.ALIGNMENT
, B.BEVEL
, B.CASE_RESTRICTION
, T.DEFAULT_VALUE
, B.ENABLED
, B.FORMAT_MASK
, B.HEIGHT
, B.INFORMATION_FORMULA_ID
, B.INFORMATION_PARAMETER_ITEM_ID1
, B.INFORMATION_PARAMETER_ITEM_ID2
, B.INFORMATION_PARAMETER_ITEM_ID3
, B.INFORMATION_PARAMETER_ITEM_ID4
, B.INFORMATION_PARAMETER_ITEM_ID5
, T.INFORMATION_PROMPT
, B.INSERT_ALLOWED
, T.LABEL
, B.PROMPT_ALIGNMENT_OFFSET
, B.PROMPT_DISPLAY_STYLE
, B.PROMPT_EDGE
, B.PROMPT_EDGE_ALIGNMENT
, B.PROMPT_EDGE_OFFSET
, T.PROMPT_TEXT
, B.PROMPT_TEXT_ALIGNMENT
, B.QUERY_ALLOWED
, T.TOOLTIP_TEXT
, B.REQUIRED
, B.UPDATE_ALLOWED
, B.VALIDATION_FORMULA_ID
, B.VALIDATION_PARAMETER_ITEM_ID1
, B.VALIDATION_PARAMETER_ITEM_ID2
, B.VALIDATION_PARAMETER_ITEM_ID3
, B.VALIDATION_PARAMETER_ITEM_ID4
, B.VALIDATION_PARAMETER_ITEM_ID5
, B.VISIBLE
, B.WIDTH
, B.X_POSITION
, B.Y_POSITION
, B.INFORMATION_CATEGORY
, B.INFORMATION1
, B.INFORMATION2
, B.INFORMATION3
, B.INFORMATION4
, B.INFORMATION5
, B.INFORMATION6
, B.INFORMATION7
, B.INFORMATION8
, B.INFORMATION9
, B.INFORMATION10
, B.INFORMATION11
, B.INFORMATION12
, B.INFORMATION13
, B.INFORMATION14
, B.INFORMATION15
, B.INFORMATION16
, B.INFORMATION17
, B.INFORMATION18
, B.INFORMATION19
, B.INFORMATION20
, B.INFORMATION21
, B.INFORMATION22
, B.INFORMATION23
, B.INFORMATION24
, B.INFORMATION25
, B.INFORMATION26
, B.INFORMATION27
, B.INFORMATION28
, B.INFORMATION29
, B.INFORMATION30
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.NEXT_NAVIGATION_ITEM_ID
, B.PREVIOUS_NAVIGATION_ITEM_ID
FROM HR_ITEM_PROPERTIES_B B
, HR_ITEM_PROPERTIES_TL T
WHERE B.ITEM_PROPERTY_ID = T.ITEM_PROPERTY_ID
AND T.LANGUAGE = USERENV('LANG')