View: PA_RES_SCH_TIMELINE_ROWLBL_V

Product:	PA - Projects
Description:	The purpose of this view is to provide row label data for the resource schedule timeline
Implementation/DBA Data:	APPS.PA_RES_SCH_TIMELINE_ROWLBL_V

View Text

SELECT TIMELINE.ROW_LABEL_ID
, TIMELINE.ROW_LABEL_TYPE
, TIMELINE.RESOURCE_ID
, TIMELINE.RESOURCE_NAME
, TIMELINE.SCH_UPD_PENDING_FLAG
, PER.PERSON_ID RESOURCE_ANALYST_ID
, RES.PERSON_ID
, RES.RESOURCE_ORGANIZATION_ID
, PA_EXPENDITURES_UTILS.GETORGTLNAME(RES.RESOURCE_ORGANIZATION_ID) ORGANIZATION_NAME
, RES.MANAGER_ID
, RES.MANAGER_NAME
, RES.RESOURCE_JOB_LEVEL
FROM PA_TIMELINE_ROW_LABEL TIMELINE
, PA_RESOURCES_DENORM RES
, FND_GRANTS FG
, FND_OBJECTS FOB
, WF_ROLES WF
, PER_ALL_PEOPLE_F PER
WHERE TIMELINE.ROW_LABEL_TYPE = 'RESOURCE'
AND TIMELINE.RESOURCE_ID = RES.RESOURCE_ID
AND FG.INSTANCE_PK1_VALUE(+) = TO_CHAR(RES.RESOURCE_ORGANIZATION_ID)
AND FG.INSTANCE_TYPE(+) = 'INSTANCE'
AND FG.OBJECT_ID = FOB.OBJECT_ID(+)
AND FOB.OBJ_NAME(+) = 'ORGANIZATION'
AND FG.MENU_ID(+) = PA_SECURITY_PVT.GET_MENU_ID('PA_PRM_RES_AUTH')
AND FG.GRANTEE_TYPE(+) = 'USER'
AND TRUNC(SYSDATE) BETWEEN TRUNC(RES.RESOURCE_EFFECTIVE_START_DATE)
AND TRUNC(RES.RESOURCE_EFFECTIVE_END_DATE)
AND FG.GRANTEE_KEY = WF.NAME
AND WF.ORIG_SYSTEM = 'HZ_PARTY'
AND PER.PARTY_ID = WF.ORIG_SYSTEM_ID
AND SYSDATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE

Columns