SELECT B.ROWID ,B.TAB_PAGE_PROPERTY_ID ,B.OBJECT_VERSION_NUMBER ,B.FORM_TAB_PAGE_ID ,B.TEMPLATE_TAB_PAGE_ID ,T.LABEL ,B.NAVIGATION_DIRECTION ,B.VISIBLE ,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 FROM HR_TAB_PAGE_PROPERTIES_B B ,HR_TAB_PAGE_PROPERTIES_TL T WHERE B.TAB_PAGE_PROPERTY_ID = T.TAB_PAGE_PROPERTY_ID AND T.LANGUAGE = USERENV('LANG')
SELECT B.ROWID
, B.TAB_PAGE_PROPERTY_ID
, B.OBJECT_VERSION_NUMBER
, B.FORM_TAB_PAGE_ID
, B.TEMPLATE_TAB_PAGE_ID
, T.LABEL
, B.NAVIGATION_DIRECTION
, B.VISIBLE
, 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
FROM HR_TAB_PAGE_PROPERTIES_B B
, HR_TAB_PAGE_PROPERTIES_TL T
WHERE B.TAB_PAGE_PROPERTY_ID = T.TAB_PAGE_PROPERTY_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|