VIEW: APPS.PER_GRADE_SPINES_D

Source

View Text - Preformatted

SELECT GSPINE.GRADE_SPINE_ID , GSPINE.EFFECTIVE_START_DATE , GSPINE.EFFECTIVE_END_DATE , PARENT.NAME ,GDT.NAME , POINT.SPINAL_POINT , GSPINE.LAST_UPDATE_DATE , FUSER.USER_NAME FROM PER_GRADE_SPINES_F GSPINE , PER_PARENT_SPINES PARENT , PER_GRADES_TL GDT , PER_SPINAL_POINTS POINT , PER_SPINAL_POINT_STEPS_F STEP , FND_USER FUSER WHERE PARENT.PARENT_SPINE_ID = GSPINE.PARENT_SPINE_ID AND GDT.GRADE_ID = GSPINE.GRADE_ID AND GDT.LANGUAGE = userenv('LANG') AND STEP.STEP_ID = GSPINE.CEILING_STEP_ID AND GSPINE.EFFECTIVE_START_DATE BETWEEN STEP.EFFECTIVE_START_DATE AND STEP.EFFECTIVE_END_DATE AND POINT.SPINAL_POINT_ID = STEP.SPINAL_POINT_ID AND FUSER.USER_ID (+)= GSPINE.LAST_UPDATED_BY

View Text - HTML Formatted

SELECT GSPINE.GRADE_SPINE_ID
, GSPINE.EFFECTIVE_START_DATE
, GSPINE.EFFECTIVE_END_DATE
, PARENT.NAME
, GDT.NAME
, POINT.SPINAL_POINT
, GSPINE.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PER_GRADE_SPINES_F GSPINE
, PER_PARENT_SPINES PARENT
, PER_GRADES_TL GDT
, PER_SPINAL_POINTS POINT
, PER_SPINAL_POINT_STEPS_F STEP
, FND_USER FUSER
WHERE PARENT.PARENT_SPINE_ID = GSPINE.PARENT_SPINE_ID
AND GDT.GRADE_ID = GSPINE.GRADE_ID
AND GDT.LANGUAGE = USERENV('LANG')
AND STEP.STEP_ID = GSPINE.CEILING_STEP_ID
AND GSPINE.EFFECTIVE_START_DATE BETWEEN STEP.EFFECTIVE_START_DATE
AND STEP.EFFECTIVE_END_DATE
AND POINT.SPINAL_POINT_ID = STEP.SPINAL_POINT_ID
AND FUSER.USER_ID (+)= GSPINE.LAST_UPDATED_BY