VIEW: APPS.PA_REP_RES_CAP_GL_V

Source

View Text - Preformatted

SELECT prd.resource_id, prd.resource_name, prd.manager_id, prd.manager_name, prd.resource_organization_id, glp.period_year, glp.quarter_num, glp.period_name, glp.period_set_name, glp.period_num, pa_resource_utils.get_res_capacity(prd.resource_id, glp.start_date, glp.end_date), pj.name, prd.resource_job_level, prd.resource_person_type, pai.org_id from pa_resources_denorm prd, gl_periods glp, gl_sets_of_books glsob, pa_implementations pai, per_jobs pj WHERE glp.start_date BETWEEN prd.resource_effective_start_date AND prd.resource_effective_end_date AND prd.job_id = pj.job_id AND prd.schedulable_flag = 'Y' AND pai.set_of_books_id = glsob.set_of_books_id AND glsob.period_set_name = glp.period_set_name AND glsob.accounted_period_type = glp.period_type

View Text - HTML Formatted

SELECT PRD.RESOURCE_ID
, PRD.RESOURCE_NAME
, PRD.MANAGER_ID
, PRD.MANAGER_NAME
, PRD.RESOURCE_ORGANIZATION_ID
, GLP.PERIOD_YEAR
, GLP.QUARTER_NUM
, GLP.PERIOD_NAME
, GLP.PERIOD_SET_NAME
, GLP.PERIOD_NUM
, PA_RESOURCE_UTILS.GET_RES_CAPACITY(PRD.RESOURCE_ID
, GLP.START_DATE
, GLP.END_DATE)
, PJ.NAME
, PRD.RESOURCE_JOB_LEVEL
, PRD.RESOURCE_PERSON_TYPE
, PAI.ORG_ID
FROM PA_RESOURCES_DENORM PRD
, GL_PERIODS GLP
, GL_SETS_OF_BOOKS GLSOB
, PA_IMPLEMENTATIONS PAI
, PER_JOBS PJ
WHERE GLP.START_DATE BETWEEN PRD.RESOURCE_EFFECTIVE_START_DATE
AND PRD.RESOURCE_EFFECTIVE_END_DATE
AND PRD.JOB_ID = PJ.JOB_ID
AND PRD.SCHEDULABLE_FLAG = 'Y'
AND PAI.SET_OF_BOOKS_ID = GLSOB.SET_OF_BOOKS_ID
AND GLSOB.PERIOD_SET_NAME = GLP.PERIOD_SET_NAME
AND GLSOB.ACCOUNTED_PERIOD_TYPE = GLP.PERIOD_TYPE