VIEW: APPS.PER_SPINAL_POINT_STEPS_V

Source

View Text - Preformatted

SELECT SPS.ROWID , SPS.STEP_ID , SPS.EFFECTIVE_START_DATE , SPS.EFFECTIVE_END_DATE , SPS.BUSINESS_GROUP_ID , SPS.SPINAL_POINT_ID , SPS.GRADE_SPINE_ID , SPS.SEQUENCE , SPS.REQUEST_ID , SPS.PROGRAM_APPLICATION_ID , SPS.PROGRAM_ID , SPS.PROGRAM_UPDATE_DATE , SPS.LAST_UPDATE_DATE , SPS.LAST_UPDATED_BY , SPS.LAST_UPDATE_LOGIN , SPS.CREATED_BY , SPS.CREATION_DATE , SP.SPINAL_POINT , SPS.INFORMATION1 , SPS.INFORMATION2 , SPS.INFORMATION3 , SPS.INFORMATION4 , SPS.INFORMATION5 , SPS.INFORMATION6 , SPS.INFORMATION7 , SPS.INFORMATION8 , SPS.INFORMATION9 , SPS.INFORMATION10 , SPS.INFORMATION11 , SPS.INFORMATION12 , SPS.INFORMATION13 , SPS.INFORMATION14 , SPS.INFORMATION15 , SPS.INFORMATION16 , SPS.INFORMATION17 , SPS.INFORMATION18 , SPS.INFORMATION19 , SPS.INFORMATION20 , SPS.INFORMATION21 , SPS.INFORMATION22 , SPS.INFORMATION23 , SPS.INFORMATION24 , SPS.INFORMATION25 , SPS.INFORMATION26 , SPS.INFORMATION27 , SPS.INFORMATION28 , SPS.INFORMATION29 , SPS.INFORMATION30 , SPS.INFORMATION_CATEGORY , SPS.OBJECT_VERSION_NUMBER FROM PER_SPINAL_POINT_STEPS_F SPS, PER_SPINAL_POINTS SP, FND_SESSIONS FND WHERE SPS.SPINAL_POINT_ID = SP.SPINAL_POINT_ID AND FND.SESSION_ID = USERENV('sessionid') AND FND.EFFECTIVE_DATE BETWEEN SPS.EFFECTIVE_START_DATE AND SPS.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT SPS.ROWID
, SPS.STEP_ID
, SPS.EFFECTIVE_START_DATE
, SPS.EFFECTIVE_END_DATE
, SPS.BUSINESS_GROUP_ID
, SPS.SPINAL_POINT_ID
, SPS.GRADE_SPINE_ID
, SPS.SEQUENCE
, SPS.REQUEST_ID
, SPS.PROGRAM_APPLICATION_ID
, SPS.PROGRAM_ID
, SPS.PROGRAM_UPDATE_DATE
, SPS.LAST_UPDATE_DATE
, SPS.LAST_UPDATED_BY
, SPS.LAST_UPDATE_LOGIN
, SPS.CREATED_BY
, SPS.CREATION_DATE
, SP.SPINAL_POINT
, SPS.INFORMATION1
, SPS.INFORMATION2
, SPS.INFORMATION3
, SPS.INFORMATION4
, SPS.INFORMATION5
, SPS.INFORMATION6
, SPS.INFORMATION7
, SPS.INFORMATION8
, SPS.INFORMATION9
, SPS.INFORMATION10
, SPS.INFORMATION11
, SPS.INFORMATION12
, SPS.INFORMATION13
, SPS.INFORMATION14
, SPS.INFORMATION15
, SPS.INFORMATION16
, SPS.INFORMATION17
, SPS.INFORMATION18
, SPS.INFORMATION19
, SPS.INFORMATION20
, SPS.INFORMATION21
, SPS.INFORMATION22
, SPS.INFORMATION23
, SPS.INFORMATION24
, SPS.INFORMATION25
, SPS.INFORMATION26
, SPS.INFORMATION27
, SPS.INFORMATION28
, SPS.INFORMATION29
, SPS.INFORMATION30
, SPS.INFORMATION_CATEGORY
, SPS.OBJECT_VERSION_NUMBER
FROM PER_SPINAL_POINT_STEPS_F SPS
, PER_SPINAL_POINTS SP
, FND_SESSIONS FND
WHERE SPS.SPINAL_POINT_ID = SP.SPINAL_POINT_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN SPS.EFFECTIVE_START_DATE
AND SPS.EFFECTIVE_END_DATE