VIEW: APPS.PA_RES_SCH_TIMELINE_ROWLBL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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