DBA Data[Home] [Help]

VIEW: APPS.PER_SPINAL_POINT_STEPS_D

Source

View Text - Preformatted

SELECT STEP.STEP_ID , STEP.EFFECTIVE_START_DATE , STEP.EFFECTIVE_END_DATE , POINT.SPINAL_POINT , STEP.LAST_UPDATE_DATE , FUSER.USER_NAME FROM PER_SPINAL_POINT_STEPS_F STEP , PER_SPINAL_POINTS POINT , FND_USER FUSER WHERE POINT.SPINAL_POINT_ID = STEP.SPINAL_POINT_ID AND FUSER.USER_ID (+)= STEP.LAST_UPDATED_BY
View Text - HTML Formatted

SELECT STEP.STEP_ID
, STEP.EFFECTIVE_START_DATE
, STEP.EFFECTIVE_END_DATE
, POINT.SPINAL_POINT
, STEP.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PER_SPINAL_POINT_STEPS_F STEP
, PER_SPINAL_POINTS POINT
, FND_USER FUSER
WHERE POINT.SPINAL_POINT_ID = STEP.SPINAL_POINT_ID
AND FUSER.USER_ID (+)= STEP.LAST_UPDATED_BY