----------------------------------------------
---  DDL for Table SRC_IPOT_REPORT_RAW_TB  ---
----------------------------------------------

  CREATE TABLE "OTHQ_OWN"."SRC_IPOT_REPORT_RAW_TB" 
   (	"FORECASTING_ID" NUMBER, 
	"PLANNING_ID" NUMBER, 
	"CREATED_DATE" DATE, 
	"CREATED_BY" VARCHAR2(16 BYTE) COLLATE "USING_NLS_COMP", 
	"BUDGET_LABEL" VARCHAR2(8 BYTE) COLLATE "USING_NLS_COMP", 
	"REQUESTED_DELIVERY_DATE" DATE, 
	"PRIORITY_NAME" VARCHAR2(16 BYTE) COLLATE "USING_NLS_COMP", 
	"CATEGORY_PROJECT_TXT" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"IMPACT_TXT" VARCHAR2(64 BYTE) COLLATE "USING_NLS_COMP", 
	"MANAGER_USER_ID" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"PROVISIONING_TEAM_USER_ID" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"STATUS_NAME" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"TEAM_NAME" VARCHAR2(64 BYTE) COLLATE "USING_NLS_COMP", 
	"PROJECT_NAME" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"FORECASTING_GROUP_NAME" VARCHAR2(16 BYTE) COLLATE "USING_NLS_COMP", 
	"JUSTIFICATION" VARCHAR2(512 BYTE) COLLATE "USING_NLS_COMP", 
	"TENANCY_NAME" VARCHAR2(16 BYTE) COLLATE "USING_NLS_COMP", 
	"COMPARTMENT_NAME" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"SERVICE_ENVIRONMENT" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"DEPLOYMENT" VARCHAR2(8 BYTE) COLLATE "USING_NLS_COMP", 
	"REGION_KEY" VARCHAR2(8 BYTE) COLLATE "USING_NLS_COMP", 
	"DC_NAME" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"TEMPLATE_TYPE_NAME" VARCHAR2(16 BYTE) COLLATE "USING_NLS_COMP", 
	"TEMPLATE_NAME" VARCHAR2(64 BYTE) COLLATE "USING_NLS_COMP", 
	"UNIT" VARCHAR2(16 BYTE) COLLATE "USING_NLS_COMP", 
	"ICCR_SKU_NBR" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"PL_PRICE" NUMBER, 
	"CORES_PER_INSTANCE" NUMBER, 
	"INSTANCE_COUNT" NUMBER, 
	"QUANTITY" NUMBER, 
	"INFLATED_FLG" VARCHAR2(8 BYTE) COLLATE "USING_NLS_COMP", 
	"ACTUAL_INSTANCE_COUNT" NUMBER, 
	"OCI_COMMITTED_DATE" DATE, 
	"ODP_STATUS_NAME" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"ODP_STATUS_UPDATED_BY" VARCHAR2(8 BYTE) COLLATE "USING_NLS_COMP", 
	"ODP_STATUS_UPDATED_DT" DATE, 
	"ODP_SUPPORT_DT" VARCHAR2(8 BYTE) COLLATE "USING_NLS_COMP", 
	"NSOCI_JIRA_ID" VARCHAR2(8 BYTE) COLLATE "USING_NLS_COMP", 
	"SERVICE_NAME" VARCHAR2(32 BYTE) COLLATE "USING_NLS_COMP", 
	"LIMIT_NAME" VARCHAR2(64 BYTE) COLLATE "USING_NLS_COMP"
   )  DEFAULT COLLATION "USING_NLS_COMP" SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 
 COLUMN STORE COMPRESS FOR QUERY HIGH ROW LEVEL LOCKING LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA" ;
  GRANT SELECT ON "OTHQ_OWN"."SRC_IPOT_REPORT_RAW_TB" TO "USER_HORIZON";
