VIEW: APPS.HR_TEMPLATE_CANVASES

Source

View Text - Preformatted

SELECT C.ROWID ,C.TEMPLATE_CANVAS_ID ,C.OBJECT_VERSION_NUMBER ,C.TEMPLATE_WINDOW_ID ,C.FORM_CANVAS_ID ,P.HEIGHT ,P.VISIBLE ,P.WIDTH ,P.X_POSITION ,P.Y_POSITION ,P.INFORMATION_CATEGORY ,P.INFORMATION1 ,P.INFORMATION2 ,P.INFORMATION3 ,P.INFORMATION4 ,P.INFORMATION5 ,P.INFORMATION6 ,P.INFORMATION7 ,P.INFORMATION8 ,P.INFORMATION9 ,P.INFORMATION10 ,P.INFORMATION11 ,P.INFORMATION12 ,P.INFORMATION13 ,P.INFORMATION14 ,P.INFORMATION15 ,P.INFORMATION16 ,P.INFORMATION17 ,P.INFORMATION18 ,P.INFORMATION19 ,P.INFORMATION20 ,P.INFORMATION21 ,P.INFORMATION22 ,P.INFORMATION23 ,P.INFORMATION24 ,P.INFORMATION25 ,P.INFORMATION26 ,P.INFORMATION27 ,P.INFORMATION28 ,P.INFORMATION29 ,P.INFORMATION30 ,C.LAST_UPDATE_DATE ,C.LAST_UPDATED_BY ,C.LAST_UPDATE_LOGIN ,C.CREATED_BY ,C.CREATION_DATE FROM HR_CANVAS_PROPERTIES P ,HR_TEMPLATE_CANVASES_B C WHERE P.TEMPLATE_CANVAS_ID (+) = C.TEMPLATE_CANVAS_ID

View Text - HTML Formatted

SELECT C.ROWID
, C.TEMPLATE_CANVAS_ID
, C.OBJECT_VERSION_NUMBER
, C.TEMPLATE_WINDOW_ID
, C.FORM_CANVAS_ID
, P.HEIGHT
, P.VISIBLE
, P.WIDTH
, P.X_POSITION
, P.Y_POSITION
, P.INFORMATION_CATEGORY
, P.INFORMATION1
, P.INFORMATION2
, P.INFORMATION3
, P.INFORMATION4
, P.INFORMATION5
, P.INFORMATION6
, P.INFORMATION7
, P.INFORMATION8
, P.INFORMATION9
, P.INFORMATION10
, P.INFORMATION11
, P.INFORMATION12
, P.INFORMATION13
, P.INFORMATION14
, P.INFORMATION15
, P.INFORMATION16
, P.INFORMATION17
, P.INFORMATION18
, P.INFORMATION19
, P.INFORMATION20
, P.INFORMATION21
, P.INFORMATION22
, P.INFORMATION23
, P.INFORMATION24
, P.INFORMATION25
, P.INFORMATION26
, P.INFORMATION27
, P.INFORMATION28
, P.INFORMATION29
, P.INFORMATION30
, C.LAST_UPDATE_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_LOGIN
, C.CREATED_BY
, C.CREATION_DATE
FROM HR_CANVAS_PROPERTIES P
, HR_TEMPLATE_CANVASES_B C
WHERE P.TEMPLATE_CANVAS_ID (+) = C.TEMPLATE_CANVAS_ID