[Home] [Help]
View: PA_REP_RES_CAP_GL_V
Product: | PA - Projects |
Description: | PA_REP_RES_CAP_GL_V is a view that shows resource capacity hours for a gl_period |
Implementation/DBA Data: |
APPS.PA_REP_RES_CAP_GL_V
|
View Text
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
Columns
Name |
RESOURCE_ID |
RESOURCE_NAME |
MANAGER_ID |
MANAGER_NAME |
ORGANIZATION_ID |
YEAR |
QUARTER |
GL_PERIOD_NAME |
GL_PERIOD_SET_NAME |
GL_PERIOD_NUMBER |
CAPACITY_HOURS |
JOB_NAME |
RESOURCE_JOB_LEVEL |
PERSON_TYPE |
ORG_ID |