View: PER_SPINAL_POINT_PLACEMENTS_D

Product:	PER - Human Resources
Description:	Used by Datetrack History
Implementation/DBA Data:	APPS.PER_SPINAL_POINT_PLACEMENTS_D

View Text

SELECT PLACE.PLACEMENT_ID
, PLACE.EFFECTIVE_START_DATE
, PLACE.EFFECTIVE_END_DATE
, POINT.SPINAL_POINT
, FND1.MEANING
, HR1.MEANING
, PLACE.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PER_SPINAL_POINT_PLACEMENTS_F PLACE
, PER_SPINAL_POINT_STEPS_F STEP
, PER_SPINAL_POINTS POINT
, FND_LOOKUPS FND1
, HR_LOOKUPS HR1
, FND_USER FUSER
WHERE STEP.STEP_ID = PLACE.STEP_ID
AND PLACE.EFFECTIVE_START_DATE BETWEEN STEP.EFFECTIVE_START_DATE
AND STEP.EFFECTIVE_END_DATE
AND POINT.SPINAL_POINT_ID = STEP.SPINAL_POINT_ID
AND FND1.LOOKUP_CODE = PLACE.AUTO_INCREMENT_FLAG
AND FND1.LOOKUP_TYPE = 'YES_NO'
AND HR1.LOOKUP_CODE (+)= PLACE.REASON
AND HR1.LOOKUP_TYPE (+)= 'PLACEMENT_REASON'
AND FUSER.USER_ID (+)= PLACE.LAST_UPDATED_BY

Columns