VIEW: APPS.HR_ITEM_PROPERTIES_VL

Source

View Text - Preformatted

SELECT B.ROWID ,B.OBJECT_version_NUMBER ,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')

View Text - HTML Formatted

SELECT B.ROWID
, B.OBJECT_VERSION_NUMBER
, 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')