VIEW: APPS.PER_SPINAL_POINT_PLACEMENTS_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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