Product: | CRP - Capacity |
---|---|
Description: | Bucketed resource utilization view |
Implementation/DBA Data: | APPS.CRP_CAPACITY_PLANS_V |
SELECT CAP.ROWID
, CAP.BILL_OF_RESOURCE
, CAP.CREATED_BY
, CAP.CREATION_DATE
, CAP.DEPARTMENT_CLASS
, CAP.DEPARTMENT_ID
, CAP.DEPARTMENT_NAME
, CAP.DESIGNATOR
, CAP.LAST_UPDATED_BY
, CAP.LAST_UPDATE_DATE
, CAP.LAST_UPDATE_LOGIN
, CAP.LINE_ID
, CAP.LINE_NAME
, CAP.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, CAP.PERIOD1
, CAP.PERIOD10
, CAP.PERIOD11
, CAP.PERIOD12
, CAP.PERIOD13
, CAP.PERIOD14
, CAP.PERIOD15
, CAP.PERIOD16
, CAP.PERIOD17
, CAP.PERIOD18
, CAP.PERIOD19
, CAP.PERIOD2
, CAP.PERIOD20
, CAP.PERIOD21
, CAP.PERIOD22
, CAP.PERIOD23
, CAP.PERIOD24
, CAP.PERIOD25
, CAP.PERIOD26
, CAP.PERIOD27
, CAP.PERIOD28
, CAP.PERIOD29
, CAP.PERIOD3
, CAP.PERIOD30
, CAP.PERIOD31
, CAP.PERIOD32
, CAP.PERIOD33
, CAP.PERIOD34
, CAP.PERIOD35
, CAP.PERIOD36
, CAP.PERIOD4
, CAP.PERIOD5
, CAP.PERIOD6
, CAP.PERIOD7
, CAP.PERIOD8
, CAP.PERIOD9
, CAP.QUERY_ID
, CAP.RESOURCE_ID
, CAP.RESOURCE_NAME
, CAP.RESOURCE_GROUP_NAME
, CAP.RESOURCE_TYPE
, CAP.SIMULATION_SET
, CAP.TYPE_ID
, LU1.MEANING
FROM MFG_LOOKUPS LU1
, MTL_PARAMETERS ORG
, CRP_CAPACITY_PLANS CAP
WHERE (( LU1.LOOKUP_TYPE = 'CRP_HORIZONTAL_PLAN_DIS_TYPE'
AND CAP.LINE_ID = -1) OR ( LU1.LOOKUP_TYPE = 'CRP_HORIZONTAL_PLAN_REP_TYPE'
AND CAP.LINE_ID <>-1))
AND LU1.LOOKUP_CODE = TYPE_ID
AND ORG.ORGANIZATION_ID = CAP.ORGANIZATION_ID