VIEW: APPS.CRP_CAPACITY_PLANS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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