FND Design Data [Home] [Help]

View: PER_SPINAL_POINT_STEPS_D

Product: PER - Human Resources
Description: Used by Datetrack History
Implementation/DBA Data: ViewAPPS.PER_SPINAL_POINT_STEPS_D
View Text

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

Columns

Name
STEP_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
SPINAL_POINT
LAST_UPDATE_DATE
LAST_UPDATED_BY