Subversion Repositories DevTools

Rev

Rev 3947 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3947 Rev 4534
Line 1... Line 1...
1 
--------------------------------------------------------
 1 
--------------------------------------------------------
2 
--  File created - Thursday-August-01-2013
2 
--  File created - Tuesday-September-23-2014
3 
--------------------------------------------------------
 3 
--------------------------------------------------------
- 
 
 4 
--------------------------------------------------------
- 
 
 5 
--  DDL for Type DEPMGR_NUMBER_TAB_T
- 
 
 6 
--------------------------------------------------------
- 
 
 7 
 
- 
 
 8 
  CREATE OR REPLACE TYPE "DEPMGR_NUMBER_TAB_T" as TABLE of NUMBER
- 
 
 9 
 
- 
 
 10 
/
- 
 
 11 
 
- 
 
 12 
/
- 
 
 13 
--------------------------------------------------------
- 
 
 14 
--  DDL for Type SPLIT_TBL
- 
 
 15 
--------------------------------------------------------
- 
 
 16 
 
- 
 
 17 
  CREATE OR REPLACE TYPE "SPLIT_TBL" as table of varchar2(32767)
- 
 
 18 
 
- 
 
 19 
/
- 
 
 20 
 
- 
 
 21 
/
- 
 
 22 
--------------------------------------------------------
- 
 
 23 
--  DDL for Sequence SEQ_ARTICLE_ID
- 
 
 24 
--------------------------------------------------------
- 
 
 25 
 
- 
 
 26 
   CREATE SEQUENCE  "SEQ_ARTICLE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 10000 CACHE 20 ORDER  NOCYCLE ;
- 
 
 27 
/
- 
 
 28 
--------------------------------------------------------
- 
 
 29 
--  DDL for Sequence SEQ_BASE_ENV_ID
- 
 
 30 
--------------------------------------------------------
- 
 
 31 
 
- 
 
 32 
   CREATE SEQUENCE  "SEQ_BASE_ENV_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 81675 CACHE 20 ORDER  NOCYCLE ;
- 
 
 33 
/
- 
 
 34 
--------------------------------------------------------
- 
 
 35 
--  DDL for Sequence SEQ_BOM_ID
- 
 
 36 
--------------------------------------------------------
- 
 
 37 
 
- 
 
 38 
   CREATE SEQUENCE  "SEQ_BOM_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 85984 CACHE 20 ORDER  NOCYCLE ;
- 
 
 39 
/
- 
 
 40 
--------------------------------------------------------
- 
 
 41 
--  DDL for Sequence SEQ_BOM_NAME_ID
- 
 
 42 
--------------------------------------------------------
- 
 
 43 
 
- 
 
 44 
   CREATE SEQUENCE  "SEQ_BOM_NAME_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1501 CACHE 20 ORDER  NOCYCLE ;
- 
 
 45 
/
- 
 
 46 
--------------------------------------------------------
- 
 
 47 
--  DDL for Sequence SEQ_BRANCH_ID
- 
 
 48 
--------------------------------------------------------
- 
 
 49 
 
- 
 
 50 
   CREATE SEQUENCE  "SEQ_BRANCH_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 4941 CACHE 20 ORDER  NOCYCLE ;
- 
 
 51 
/
- 
 
 52 
--------------------------------------------------------
- 
 
 53 
--  DDL for Sequence SEQ_HARDWARE_NAME_ID
- 
 
 54 
--------------------------------------------------------
- 
 
 55 
 
- 
 
 56 
   CREATE SEQUENCE  "SEQ_HARDWARE_NAME_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 61 CACHE 20 ORDER  NOCYCLE ;
- 
 
 57 
/
- 
 
 58 
--------------------------------------------------------
- 
 
 59 
--  DDL for Sequence SEQ_MSG_ID
- 
 
 60 
--------------------------------------------------------
- 
 
 61 
 
- 
 
 62 
   CREATE SEQUENCE  "SEQ_MSG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 462 CACHE 20 ORDER  NOCYCLE ;
- 
 
 63 
/
- 
 
 64 
--------------------------------------------------------
- 
 
 65 
--  DDL for Sequence SEQ_NODE_ID
- 
 
 66 
--------------------------------------------------------
- 
 
 67 
 
- 
 
 68 
   CREATE SEQUENCE  "SEQ_NODE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 171695 CACHE 20 ORDER  NOCYCLE ;
- 
 
 69 
/
- 
 
 70 
--------------------------------------------------------
- 
 
 71 
--  DDL for Sequence SEQ_OS_ID
- 
 
 72 
--------------------------------------------------------
- 
 
 73 
 
- 
 
 74 
   CREATE SEQUENCE  "SEQ_OS_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 177041 CACHE 20 ORDER  NOCYCLE ;
- 
 
 75 
/
- 
 
 76 
--------------------------------------------------------
- 
 
 77 
--  DDL for Sequence SEQ_PROC_ID
- 
 
 78 
--------------------------------------------------------
- 
 
 79 
 
- 
 
 80 
   CREATE SEQUENCE  "SEQ_PROC_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1441 CACHE 20 ORDER  NOCYCLE ;
- 
 
 81 
/
- 
 
 82 
--------------------------------------------------------
- 
 
 83 
--  DDL for Sequence SEQ_PROJ_ID
- 
 
 84 
--------------------------------------------------------
- 
 
 85 
 
- 
 
 86 
   CREATE SEQUENCE  "SEQ_PROJ_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 881 CACHE 20 ORDER  NOCYCLE ;
- 
 
 87 
/
- 
 
 88 
--------------------------------------------------------
- 
 
 89 
--  DDL for Sequence SEQ_STATE_ID
- 
 
 90 
--------------------------------------------------------
- 
 
 91 
 
- 
 
 92 
   CREATE SEQUENCE  "SEQ_STATE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1621 CACHE 20 ORDER  NOCYCLE ;
- 
 
 93 
/
- 
 
 94 
--------------------------------------------------------
- 
 
 95 
--  DDL for Sequence SEQ_UNIT_TESTS
- 
 
 96 
--------------------------------------------------------
- 
 
 97 
 
- 
 
 98 
   CREATE SEQUENCE  "SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 541 CACHE 20 ORDER  NOCYCLE ;
- 
 
 99 
/
- 
 
 100 
--------------------------------------------------------
- 
 
 101 
--  DDL for Table ACTION_TRAIL
- 
 
 102 
--------------------------------------------------------
- 
 
 103 
 
- 
 
 104 
  CREATE TABLE "ACTION_TRAIL"
- 
 
 105 
   (	"ACTION_STAMP" DATE,
- 
 
 106 
	"USER_ID" NUMBER,
- 
 
 107 
	"ACTION_EVENT" NUMBER,
- 
 
 108 
	"METHOD_CALL" VARCHAR2(4000),
- 
 
 109 
	"ACTION_SCRIPT" VARCHAR2(4000),
- 
 
 110 
	"ACTION_DESCRIPTION" VARCHAR2(4000)
- 
 
 111 
   ) ;
- 
 
 112 
/
- 
 
 113 
--------------------------------------------------------
- 
 
 114 
--  DDL for Table BASE_ENV
- 
 
 115 
--------------------------------------------------------
- 
 
 116 
 
- 
 
 117 
  CREATE TABLE "BASE_ENV"
- 
 
 118 
   (	"BASE_ENV_ID" NUMBER,
- 
 
 119 
	"BOS_ID" NUMBER,
- 
 
 120 
	"BASE_ENV_NAME" VARCHAR2(50),
- 
 
 121 
	"OLD_BASE_ENV_ID" NUMBER,
- 
 
 122 
	"BOM_ID" NUMBER
- 
 
 123 
   ) ;
- 
 
 124 
/
- 
 
 125 
--------------------------------------------------------
- 
 
 126 
--  DDL for Table BASE_ENV_CONTENTS
- 
 
 127 
--------------------------------------------------------
- 
 
 128 
 
- 
 
 129 
  CREATE TABLE "BASE_ENV_CONTENTS"
- 
 
 130 
   (	"BASE_ENV_ID" NUMBER,
- 
 
 131 
	"PROD_ID" NUMBER,
- 
 
 132 
	"BASE_ENV_COMMENTS" VARCHAR2(4000),
- 
 
 133 
	"SEQ_NUM" NUMBER,
- 
 
 134 
	"IS_NODE_SPEC" VARCHAR2(2),
- 
 
 135 
	"NOT_XML" VARCHAR2(2)
- 
 
 136 
   ) ;
- 
 
 137 
/
- 
 
 138 
--------------------------------------------------------
- 
 
 139 
--  DDL for Table BOMS
- 
 
 140 
--------------------------------------------------------
- 
 
 141 
 
- 
 
 142 
  CREATE TABLE "BOMS"
- 
 
 143 
   (	"BOM_ID" NUMBER,
- 
 
 144 
	"BRANCH_ID" NUMBER,
- 
 
 145 
	"BOM_NAME_ID" NUMBER,
- 
 
 146 
	"BOM_VERSION" VARCHAR2(4000),
- 
 
 147 
	"IS_REJECTED" CHAR(1),
- 
 
 148 
	"IS_READONLY" CHAR(1),
- 
 
 149 
	"IS_HIDDEN" CHAR(1),
- 
 
 150 
	"BOM_COMMENTS" VARCHAR2(4000),
- 
 
 151 
	"BOM_LIFECYCLE" VARCHAR2(4000),
- 
 
 152 
	"OLD_BOM_ID" NUMBER,
- 
 
 153 
	"PARENT_BOM_ID" NUMBER,
- 
 
 154 
	"RTAG_ID_FK" NUMBER,
- 
 
 155 
	"PDF_ATTACHMENT_PATH" VARCHAR2(4000)
- 
 
 156 
   ) ;
- 
 
 157 
/
- 
 
 158 
--------------------------------------------------------
- 
 
 159 
--  DDL for Table BOM_CONTENTS
- 
 
 160 
--------------------------------------------------------
- 
 
 161 
 
- 
 
 162 
  CREATE TABLE "BOM_CONTENTS"
- 
 
 163 
   (	"BOM_ID" NUMBER,
- 
 
 164 
	"NODE_ID" NUMBER,
- 
 
 165 
	"SEQ_NUM" NUMBER
- 
 
 166 
   ) ;
- 
 
 167 
/
- 
 
 168 
--------------------------------------------------------
- 
 
 169 
--  DDL for Table BOM_NAMES
- 
 
 170 
--------------------------------------------------------
- 
 
 171 
 
- 
 
 172 
  CREATE TABLE "BOM_NAMES"
- 
 
 173 
   (	"BOM_NAME_ID" NUMBER,
- 
 
 174 
	"BOM_NAME" VARCHAR2(255)
- 
 
 175 
   ) ;
- 
 
 176 
/
- 
 
 177 
--------------------------------------------------------
- 
 
 178 
--  DDL for Table BOM_NOTES
- 
 
 179 
--------------------------------------------------------
- 
 
 180 
 
- 
 
 181 
  CREATE TABLE "BOM_NOTES"
- 
 
 182 
   (	"BOM_ID" NUMBER,
- 
 
 183 
	"BOM_SCOPE" NUMBER,
- 
 
 184 
	"SCOPE_ID" NUMBER,
- 
 
 185 
	"ARTICLE_ID" NUMBER
- 
 
 186 
   ) ;
- 
 
 187 
/
- 
 
 188 
--------------------------------------------------------
- 
 
 189 
--  DDL for Table BOM_STATE
- 
 
 190 
--------------------------------------------------------
- 
 
 191 
 
- 
 
 192 
  CREATE TABLE "BOM_STATE"
- 
 
 193 
   (	"BOM_ID" NUMBER,
- 
 
 194 
	"STATE_ID" NUMBER,
- 
 
 195 
	"DATE_STAMP" DATE,
- 
 
 196 
	"USER_ID" NUMBER,
- 
 
 197 
	"IS_DISPLAYED" CHAR(1)
- 
 
 198 
   ) ;
- 
 
 199 
/
- 
 
 200 
--------------------------------------------------------
- 
 
 201 
--  DDL for Table BOM_STATE20100609
- 
 
 202 
--------------------------------------------------------
- 
 
 203 
 
- 
 
 204 
  CREATE TABLE "BOM_STATE20100609"
- 
 
 205 
   (	"BOM_ID" NUMBER,
- 
 
 206 
	"STATE_ID" NUMBER,
- 
 
 207 
	"DATE_STAMP" DATE,
- 
 
 208 
	"USER_ID" NUMBER,
- 
 
 209 
	"IS_DISPLAYED" CHAR(1)
- 
 
 210 
   ) ;
- 
 
 211 
/
- 
 
 212 
--------------------------------------------------------
- 
 
 213 
--  DDL for Table BOM_TRAIL
- 
 
 214 
--------------------------------------------------------
- 
 
 215 
 
- 
 
 216 
  CREATE TABLE "BOM_TRAIL"
- 
 
 217 
   (	"BOM_ID" NUMBER,
- 
 
 218 
	"TRAIL_ACTION" VARCHAR2(4000),
- 
 
 219 
	"TRAIL_COMMENTS" VARCHAR2(4000),
- 
 
 220 
	"USER_ID" NUMBER,
- 
 
 221 
	"DATE_TIME_STAMP" DATE
- 
 
 222 
   ) ;
- 
 
 223 
/
- 
 
 224 
--------------------------------------------------------
- 
 
 225 
--  DDL for Table BOS_TYPES
- 
 
 226 
--------------------------------------------------------
- 
 
 227 
 
- 
 
 228 
  CREATE TABLE "BOS_TYPES"
- 
 
 229 
   (	"BOS_ID" NUMBER,
- 
 
 230 
	"BOS_TYPE" VARCHAR2(50),
- 
 
 231 
	"BOS_ICON" VARCHAR2(50),
- 
 
 232 
	"BOS_ORDER" NUMBER,
- 
 
 233 
	"ELECTRONIC_NAME" VARCHAR2(50)
- 
 
 234 
   ) ;
- 
 
 235 
/
- 
 
 236 
--------------------------------------------------------
- 
 
 237 
--  DDL for Table BRANCHES
- 
 
 238 
--------------------------------------------------------
- 
 
 239 
 
- 
 
 240 
  CREATE TABLE "BRANCHES"
- 
 
 241 
   (	"BRANCH_ID" NUMBER,
- 
 
 242 
	"PROJ_ID" NUMBER,
- 
 
 243 
	"BRANCH_NAME" VARCHAR2(255),
- 
 
 244 
	"RM_VTREE_FK" NUMBER,
- 
 
 245 
	"IS_HIDDEN" CHAR(1),
- 
 
 246 
	"BRANCH_COMMENTS" VARCHAR2(4000)
- 
 
 247 
   ) ;
- 
 
 248 
/
- 
 
 249 
--------------------------------------------------------
- 
 
 250 
--  DDL for Table DEF_ACTION_BUTTONS
- 
 
 251 
--------------------------------------------------------
- 
 
 252 
 
- 
 
 253 
  CREATE TABLE "DEF_ACTION_BUTTONS"
- 
 
 254 
   (	"ABTN_ID" NUMBER,
- 
 
 255 
	"ABTN_NAME" VARCHAR2(1000),
- 
 
 256 
	"TEXT" VARCHAR2(50),
- 
 
 257 
	"ACTION_LINK" VARCHAR2(4000),
- 
 
 258 
	"EVENT_HANDLER" VARCHAR2(4000),
- 
 
 259 
	"IMG_ENABLED" VARCHAR2(1000),
- 
 
 260 
	"IMG_DISABLED" VARCHAR2(1000),
- 
 
 261 
	"HINT" VARCHAR2(1000),
- 
 
 262 
	"VISIBLE" CHAR(1),
- 
 
 263 
	"ACTIVE" CHAR(1),
- 
 
 264 
	"IS_READONLY_ACTION" CHAR(1)
- 
 
 265 
   ) ;
- 
 
 266 
/
- 
 
 267 
--------------------------------------------------------
- 
 
 268 
--  DDL for Table DEF_MENU_ITEMS
- 
 
 269 
--------------------------------------------------------
- 
 
 270 
 
- 
 
 271 
  CREATE TABLE "DEF_MENU_ITEMS"
- 
 
 272 
   (	"ITEM_ID" NUMBER,
- 
 
 273 
	"ITEM_NAME" VARCHAR2(1000),
- 
 
 274 
	"TEXT" VARCHAR2(255),
- 
 
 275 
	"ACTION_LINK" VARCHAR2(255),
- 
 
 276 
	"EVENT_HANDLER" VARCHAR2(4000),
- 
 
 277 
	"IMG_ENABLED" VARCHAR2(4000),
- 
 
 278 
	"IMG_DISABLED" VARCHAR2(4000),
- 
 
 279 
	"HINT" VARCHAR2(50),
- 
 
 280 
	"VISIBLE" CHAR(1),
- 
 
 281 
	"ACTIVE" CHAR(1)
- 
 
 282 
   ) ;
- 
 
 283 
/
- 
 
 284 
--------------------------------------------------------
- 
 
 285 
--  DDL for Table DM_PROJECTS
- 
 
 286 
--------------------------------------------------------
- 
 
 287 
 
- 
 
 288 
  CREATE TABLE "DM_PROJECTS"
- 
 
 289 
   (	"PROJ_ID" NUMBER,
- 
 
 290 
	"PROJ_NAME" VARCHAR2(255),
- 
 
 291 
	"RM_PROJECTS_FK" NUMBER,
- 
 
 292 
	"IS_HIDDEN" CHAR(1),
- 
 
 293 
	"IS_DOWNLOAD" CHAR(1)
- 
 
 294 
   ) ;
- 
 
 295 
/
- 
 
 296 
--------------------------------------------------------
- 
 
 297 
--  DDL for Table HARDWARE
- 
 
 298 
--------------------------------------------------------
- 
 
 299 
 
- 
 
 300 
  CREATE TABLE "HARDWARE"
- 
 
 301 
   (	"HARDWARE_NAME_ID" NUMBER,
- 
 
 302 
	"BOM_ID" NUMBER,
- 
 
 303 
	"HARDWARE_NAME" VARCHAR2(255),
- 
 
 304 
	"TIER_NAME" VARCHAR2(255),
- 
 
 305 
	"OLD_HARDWARE_NAME_ID" NUMBER
- 
 
 306 
   ) ;
- 
 
 307 
/
- 
 
 308 
--------------------------------------------------------
- 
 
 309 
--  DDL for Table HARDWARE_NODE
- 
 
 310 
--------------------------------------------------------
- 
 
 311 
 
- 
 
 312 
  CREATE TABLE "HARDWARE_NODE"
- 
 
 313 
   (	"HARDWARE_NAME_ID" NUMBER,
- 
 
 314 
	"NODE_ID" NUMBER
- 
 
 315 
   ) ;
- 
 
 316 
/
- 
 
 317 
--------------------------------------------------------
- 
 
 318 
--  DDL for Table HIDE_PRODUCTS
- 
 
 319 
--------------------------------------------------------
- 
 
 320 
 
- 
 
 321 
  CREATE TABLE "HIDE_PRODUCTS"
- 
 
 322 
   (	"OS_ID" NUMBER,
- 
 
 323 
	"PROD_ID" NUMBER
- 
 
 324 
   ) ;
- 
 
 325 
/
- 
 
 326 
--------------------------------------------------------
- 
 
 327 
--  DDL for Table KNOWLEDGE_BASE
- 
 
 328 
--------------------------------------------------------
- 
 
 329 
 
- 
 
 330 
  CREATE TABLE "KNOWLEDGE_BASE"
- 
 
 331 
   (	"ARTICLE_ID" NUMBER,
- 
 
 332 
	"ARTICLE_TITLE" VARCHAR2(4000),
- 
 
 333 
	"ARTICLE_DETAILS" VARCHAR2(4000),
- 
 
 334 
	"VISIBILITY_LEVEL_FK" NUMBER,
- 
 
 335 
	"IS_READONLY" CHAR(1),
- 
 
 336 
	"CREATED_STAMP" DATE,
- 
 
 337 
	"CREATOR_ID" NUMBER,
- 
 
 338 
	"MOD_STAMP" DATE,
- 
 
 339 
	"MODIFIER_ID" NUMBER
- 
 
 340 
   ) ;
- 
 
 341 
/
- 
 
 342 
--------------------------------------------------------
- 
 
 343 
--  DDL for Table MESSAGE_BOARD
- 
 
 344 
--------------------------------------------------------
- 
 
 345 
 
- 
 
 346 
  CREATE TABLE "MESSAGE_BOARD"
- 
 
 347 
   (	"MSG_ID" NUMBER,
- 
 
 348 
	"MSG_DETAILS" VARCHAR2(2000),
- 
 
 349 
	"SUBMITION_DATE" DATE,
- 
 
 350 
	"EXPIRY_DATE" DATE,
- 
 
 351 
	"DUE_DATE" DATE
- 
 
 352 
   ) ;
- 
 
 353 
/
- 
 
 354 
--------------------------------------------------------
- 
 
 355 
--  DDL for Table NETWORK_NODES
- 
 
 356 
--------------------------------------------------------
- 
 
 357 
 
- 
 
 358 
  CREATE TABLE "NETWORK_NODES"
- 
 
 359 
   (	"NODE_ID" NUMBER,
- 
 
 360 
	"NODE_TYPE_ID" NUMBER,
- 
 
 361 
	"NODE_NAME" VARCHAR2(255),
- 
 
 362 
	"NODE_COMMENTS" VARCHAR2(4000),
- 
 
 363 
	"OLD_NODE_ID" NUMBER,
- 
 
 364 
	"NODE_VERSION" VARCHAR2(4000),
- 
 
 365 
	"NODE_LIFE_CYCLE" NUMBER,
- 
 
 366 
	"NOT_XML" VARCHAR2(2)
- 
 
 367 
   ) ;
- 
 
 368 
/
- 
 
 369 
--------------------------------------------------------
- 
 
 370 
--  DDL for Table NODE_TRAIL
- 
 
 371 
--------------------------------------------------------
- 
 
 372 
 
- 
 
 373 
  CREATE TABLE "NODE_TRAIL"
- 
 
 374 
   (	"NODE_ID" NUMBER,
- 
 
 375 
	"TRAIL_ACTION" VARCHAR2(4000),
- 
 
 376 
	"USER_ID" NUMBER,
- 
 
 377 
	"DATE_TIME_STAMP" DATE
- 
 
 378 
   ) ;
- 
 
 379 
/
- 
 
 380 
--------------------------------------------------------
- 
 
 381 
--  DDL for Table NODE_TYPES
- 
 
 382 
--------------------------------------------------------
- 
 
 383 
 
- 
 
 384 
  CREATE TABLE "NODE_TYPES"
- 
 
 385 
   (	"NODE_TYPE_ID" NUMBER,
- 
 
 386 
	"NODE_TYPE" VARCHAR2(50),
- 
 
 387 
	"NODE_ICON" VARCHAR2(50),
- 
 
 388 
	"NODE_IMAGE" VARCHAR2(50),
- 
 
 389 
	"NODE_ORDER" NUMBER
- 
 
 390 
   ) ;
- 
 
 391 
/
- 
 
 392 
--------------------------------------------------------
- 
 
 393 
--  DDL for Table NOTIFY_USER
- 
 
 394 
--------------------------------------------------------
- 
 
 395 
 
- 
 
 396 
  CREATE TABLE "NOTIFY_USER"
- 
 
 397 
   (	"PROJ_ID" NUMBER,
- 
 
 398 
	"USER_ID" NUMBER,
- 
 
 399 
	"EVENT_ENUM" NUMBER
- 
 
 400 
   ) ;
- 
 
 401 
/
- 
 
 402 
--------------------------------------------------------
- 
 
 403 
--  DDL for Table OPERATING_SYSTEMS
- 
 
 404 
--------------------------------------------------------
- 
 
 405 
 
- 
 
 406 
  CREATE TABLE "OPERATING_SYSTEMS"
- 
 
 407 
   (	"OS_ID" NUMBER,
- 
 
 408 
	"OS_NAME" VARCHAR2(50),
- 
 
 409 
	"NODE_ID" NUMBER,
- 
 
 410 
	"OS_COMMENTS" VARCHAR2(4000),
- 
 
 411 
	"OLD_OS_ID" NUMBER,
- 
 
 412 
	"NODE_SPEC_FILE" VARCHAR2(4000),
- 
 
 413 
	"NOT_XML" VARCHAR2(2)
- 
 
 414 
   ) ;
- 
 
 415 
/
- 
 
 416 
--------------------------------------------------------
- 
 
 417 
--  DDL for Table OS_BASE_ENV
- 
 
 418 
--------------------------------------------------------
- 
 
 419 
 
- 
 
 420 
  CREATE TABLE "OS_BASE_ENV"
- 
 
 421 
   (	"OS_ID" NUMBER,
- 
 
 422 
	"BASE_ENV_ID" NUMBER
- 
 
 423 
   ) ;
- 
 
 424 
/
- 
 
 425 
--------------------------------------------------------
- 
 
 426 
--  DDL for Table OS_CONTENTS
- 
 
 427 
--------------------------------------------------------
- 
 
 428 
 
- 
 
 429 
  CREATE TABLE "OS_CONTENTS"
- 
 
 430 
   (	"OS_ID" NUMBER,
- 
 
 431 
	"SEQ_NUM" NUMBER,
- 
 
 432 
	"PROD_ID" NUMBER,
- 
 
 433 
	"PRODUCT_COMMENTS" VARCHAR2(4000),
- 
 
 434 
	"CHANGE_LOG_FLAG" CHAR(1),
- 
 
 435 
	"IS_NODE_SPEC" VARCHAR2(2),
- 
 
 436 
	"NOT_XML" VARCHAR2(2)
- 
 
 437 
   ) ;
- 
 
 438 
 
- 
 
 439 
   COMMENT ON COLUMN "OS_CONTENTS"."CHANGE_LOG_FLAG" IS 'cvn';
- 
 
 440 
   COMMENT ON TABLE "OS_CONTENTS"  IS 'CHANGE_LOG_FLAG:
- 
 
 441 
N - new
- 
 
 442 
U - updated version';
- 
 
 443 
/
- 
 
 444 
--------------------------------------------------------
- 
 
 445 
--  DDL for Table OS_TRAIL
- 
 
 446 
--------------------------------------------------------
- 
 
 447 
 
- 
 
 448 
  CREATE TABLE "OS_TRAIL"
- 
 
 449 
   (	"OS_ID" NUMBER,
- 
 
 450 
	"TRAIL_ACTION" VARCHAR2(4000),
- 
 
 451 
	"USER_ID" NUMBER,
- 
 
 452 
	"DATE_TIME_STAMP" DATE
- 
 
 453 
   ) ;
- 
 
 454 
/
- 
 
 455 
--------------------------------------------------------
- 
 
 456 
--  DDL for Table PACKAGE_TRAIL
- 
 
 457 
--------------------------------------------------------
- 
 
 458 
 
- 
 
 459 
  CREATE TABLE "PACKAGE_TRAIL"
- 
 
 460 
   (	"PKG_ID" NUMBER,
- 
 
 461 
	"TRAIL_ACTION" VARCHAR2(4000),
- 
 
 462 
	"USER_ID" NUMBER,
- 
 
 463 
	"DATE_TIME_STAMP" DATE
- 
 
 464 
   ) ;
- 
 
 465 
/
- 
 
 466 
--------------------------------------------------------
- 
 
 467 
--  DDL for Table PROCESSES_CONFIG
- 
 
 468 
--------------------------------------------------------
- 
 
 469 
 
- 
 
 470 
  CREATE TABLE "PROCESSES_CONFIG"
- 
 
 471 
   (	"PROC_ID" NUMBER,
- 
 
 472 
	"PROD_ID" NUMBER,
- 
 
 473 
	"OS_ID" NUMBER,
- 
 
 474 
	"PKG_HEALTH_TAG" VARCHAR2(255),
- 
 
 475 
	"CMD_INTERFACE" VARCHAR2(4000),
- 
 
 476 
	"PKG_OWNER" VARCHAR2(4000),
- 
 
 477 
	"IS_INTERFACE" CHAR(1),
- 
 
 478 
	"PROC_DESCRIPTION" VARCHAR2(4000),
- 
 
 479 
	"PKG_ID" NUMBER
- 
 
 480 
   ) ;
- 
 
 481 
/
- 
 
 482 
--------------------------------------------------------
- 
 
 483 
--  DDL for Table PRODUCTION_BOM
- 
 
 484 
--------------------------------------------------------
- 
 
 485 
 
- 
 
 486 
  CREATE TABLE "PRODUCTION_BOM"
- 
 
 487 
   (	"PROJ_ID" NUMBER,
- 
 
 488 
	"BOM_ID" NUMBER,
- 
 
 489 
	"STATE_ID" NUMBER
- 
 
 490 
   ) ;
- 
 
 491 
/
- 
 
 492 
--------------------------------------------------------
- 
 
 493 
--  DDL for Table PRODUCTS_QUEUE
- 
 
 494 
--------------------------------------------------------
- 
 
 495 
 
- 
 
 496 
  CREATE TABLE "PRODUCTS_QUEUE"
- 
 
 497 
   (	"PRODQ_ID" NUMBER,
- 
 
 498 
	"PROJ_ID" NUMBER,
- 
 
 499 
	"PROD_ID" NUMBER,
- 
 
 500 
	"ARRIVAL_STAMP" DATE
- 
 
 501 
   ) ;
- 
 
 502 
/
- 
 
 503 
--------------------------------------------------------
- 
 
 504 
--  DDL for Table PRODUCT_DETAILS
- 
 
 505 
--------------------------------------------------------
- 
 
 506 
 
- 
 
 507 
  CREATE TABLE "PRODUCT_DETAILS"
- 
 
 508 
   (	"PROD_ID" NUMBER,
- 
 
 509 
	"IS_REJECTED" CHAR(1)
- 
 
 510 
   ) ;
- 
 
 511 
/
- 
 
 512 
--------------------------------------------------------
- 
 
 513 
--  DDL for Table PRODUCT_NOTES
- 
 
 514 
--------------------------------------------------------
- 
 
 515 
 
- 
 
 516 
  CREATE TABLE "PRODUCT_NOTES"
- 
 
 517 
   (	"PROD_ID" NUMBER,
- 
 
 518 
	"NOTES" VARCHAR2(4000)
- 
 
 519 
   ) ;
- 
 
 520 
/
- 
 
 521 
--------------------------------------------------------
- 
 
 522 
--  DDL for Table PRODUCT_TRAIL
- 
 
 523 
--------------------------------------------------------
- 
 
 524 
 
- 
 
 525 
  CREATE TABLE "PRODUCT_TRAIL"
- 
 
 526 
   (	"PROD_ID" NUMBER,
- 
 
 527 
	"TRAIL_ACTION" VARCHAR2(4000),
- 
 
 528 
	"USER_ID" NUMBER,
- 
 
 529 
	"DATE_TIME_STAMP" DATE
- 
 
 530 
   ) ;
- 
 
 531 
/
- 
 
 532 
--------------------------------------------------------
- 
 
 533 
--  DDL for Table REJECTION_TRAIL
- 
 
 534 
--------------------------------------------------------
- 
 
 535 
 
- 
 
 536 
  CREATE TABLE "REJECTION_TRAIL"
- 
 
 537 
   (	"ENUM_ENTITY_TYPE" NUMBER,
- 
 
 538 
	"ENTITY_ID" NUMBER,
- 
 
 539 
	"REJECT_SEQ" NUMBER,
- 
 
 540 
	"IS_REJECTED" CHAR(1),
- 
 
 541 
	"COMMENTS" VARCHAR2(4000),
- 
 
 542 
	"DATE_TIME_STAMP" DATE,
- 
 
 543 
	"USER_ID" NUMBER
- 
 
 544 
   ) ;
- 
 
 545 
/
- 
 
 546 
--------------------------------------------------------
- 
 
 547 
--  DDL for Table RELATED_ARTICLES
- 
 
 548 
--------------------------------------------------------
- 
 
 549 
 
- 
 
 550 
  CREATE TABLE "RELATED_ARTICLES"
- 
 
 551 
   (	"ARTICLE_ID" NUMBER,
- 
 
 552 
	"RARTICLE_ID" NUMBER
- 
 
 553 
   ) ;
- 
 
 554 
/
- 
 
 555 
--------------------------------------------------------
- 
 
 556 
--  DDL for Table RELEASE_AUTHORISATION
- 
 
 557 
--------------------------------------------------------
- 
 
 558 
 
- 
 
 559 
  CREATE TABLE "RELEASE_AUTHORISATION"
- 
 
 560 
   (	"PV_ID" NUMBER,
- 
 
 561 
	"BOM_ID" NUMBER,
- 
 
 562 
	"TESTER_ID" NUMBER,
- 
 
 563 
	"TESTER_COMMENTS" VARCHAR2(4000),
- 
 
 564 
	"TESTER_DATESTAMP" DATE,
- 
 
 565 
	"MANAGER_ID" NUMBER,
- 
 
 566 
	"MANAGER_COMMENTS" VARCHAR2(4000),
- 
 
 567 
	"MANAGER_DATESTAMP" DATE,
- 
 
 568 
	"IS_OFFICIAL" CHAR(1 CHAR)
- 
 
 569 
   ) ;
- 
 
 570 
/
- 
 
 571 
--------------------------------------------------------
- 
 
 572 
--  DDL for Table STATES
- 
 
 573 
--------------------------------------------------------
- 
 
 574 
 
- 
 
 575 
  CREATE TABLE "STATES"
- 
 
 576 
   (	"STATE_ID" NUMBER,
- 
 
 577 
	"PROJ_ID" NUMBER,
- 
 
 578 
	"STATE_NAME" VARCHAR2(255),
- 
 
 579 
	"STATE_SEQ" NUMBER,
- 
 
 580 
	"STATE_TYPE_ENUM" NUMBER,
- 
 
 581 
	"IS_DOWNLOAD" CHAR(1)
- 
 
 582 
   ) ;
- 
 
 583 
 
- 
 
 584 
   COMMENT ON TABLE "STATES"  IS '1 Integration
- 
 
 585 
2 Released To Testing
- 
 
 586 
3 Released To Region
- 
 
 587 
4 Released To Customer';
- 
 
 588 
/
- 
 
 589 
--------------------------------------------------------
- 
 
 590 
--  DDL for Table SYSTEM_CONFIGURATION
- 
 
 591 
--------------------------------------------------------
- 
 
 592 
 
- 
 
 593 
  CREATE TABLE "SYSTEM_CONFIGURATION"
- 
 
 594 
   (	"ITEM_NAME" VARCHAR2(255),
- 
 
 595 
	"ITEM_VALUE" VARCHAR2(4000),
- 
 
 596 
	"ITEM_DESCRIPTION" VARCHAR2(4000)
- 
 
 597 
   ) ;
- 
 
 598 
/
- 
 
 599 
--------------------------------------------------------
- 
 
 600 
--  DDL for Table TABLEOFCONTENTS
- 
 
 601 
--------------------------------------------------------
- 
 
 602 
 
- 
 
 603 
  CREATE TABLE "TABLEOFCONTENTS"
- 
 
 604 
   (	"GROUPER" VARCHAR2(1000),
- 
 
 605 
	"PAGE" NUMBER(*,0),
- 
 
 606 
	"DATETIME" DATE
- 
 
 607 
   ) ;
- 
 
 608 
/
- 
 
 609 
--------------------------------------------------------
- 
 
 610 
--  DDL for Table TEST_TYPES
- 
 
 611 
--------------------------------------------------------
- 
 
 612 
 
- 
 
 613 
  CREATE TABLE "TEST_TYPES"
- 
 
 614 
   (	"TEST_TYPE_ID" NUMBER,
- 
 
 615 
	"TEST_TYPE_NAME" VARCHAR2(50),
- 
 
 616 
	"DISPLAY_ORDER" NUMBER
- 
 
 617 
   ) ;
- 
 
 618 
/
- 
 
 619 
--------------------------------------------------------
- 
 
 620 
--  DDL for Table UNIT_TESTS
- 
 
 621 
--------------------------------------------------------
- 
 
 622 
 
- 
 
 623 
  CREATE TABLE "UNIT_TESTS"
- 
 
 624 
   (	"TEST_ID" NUMBER,
- 
 
 625 
	"PV_ID" NUMBER,
- 
 
 626 
	"TEST_TYPES_FK" NUMBER,
- 
 
 627 
	"TEST_SUMMARY" VARCHAR2(4000),
- 
 
 628 
	"COMPLETION_DATE" DATE,
- 
 
 629 
	"COMPLETED_BY" NUMBER,
- 
 
 630 
	"RESULTS_URL" VARCHAR2(2000),
- 
 
 631 
	"RESULTS_ATTACHMENT_NAME" VARCHAR2(2000)
- 
 
 632 
   ) ;
- 
 
 633 
/
- 
 
 634 
--------------------------------------------------------
- 
 
 635 
--  DDL for Table VALIDATION_RULES
- 
 
 636 
--------------------------------------------------------
- 
 
 637 
 
- 
 
 638 
  CREATE TABLE "VALIDATION_RULES"
- 
 
 639 
   (	"FIELD_NAME" VARCHAR2(1000),
- 
 
 640 
	"IS_REQUIRED" CHAR(1),
- 
 
 641 
	"IS_NUMERIC" CHAR(1),
- 
 
 642 
	"MIN_NUMERIC_VALUE" NUMBER,
- 
 
 643 
	"MAX_NUMERIC_VALUE" NUMBER,
- 
 
 644 
	"IS_DATE" CHAR(1),
- 
 
 645 
	"START_DATE" DATE,
- 
 
 646 
	"END_DATE" DATE,
- 
 
 647 
	"MIN_STRING_LENGTH" NUMBER,
- 
 
 648 
	"MAX_STRING_LENGTH" NUMBER,
- 
 
 649 
	"REGEXP" VARCHAR2(4000),
- 
 
 650 
	"REGEXP_DESCRIPTION" VARCHAR2(50)
- 
 
 651 
   ) ;
- 
 
 652 
/
- 
 
 653 
--------------------------------------------------------
- 
 
 654 
--  DDL for Index INX_BASE_ENV_BOM_ID
- 
 
 655 
--------------------------------------------------------
- 
 
 656 
 
- 
 
 657 
  CREATE INDEX "INX_BASE_ENV_BOM_ID" ON "BASE_ENV" ("BOM_ID")
- 
 
 658 
  ;
- 
 
 659 
/
- 
 
 660 
--------------------------------------------------------
- 
 
 661 
--  DDL for Index PK_BOS_TYPES
- 
 
 662 
--------------------------------------------------------
- 
 
 663 
 
- 
 
 664 
  CREATE UNIQUE INDEX "PK_BOS_TYPES" ON "BOS_TYPES" ("BOS_ID")
- 
 
 665 
  ;
- 
 
 666 
/
- 
 
 667 
--------------------------------------------------------
- 
 
 668 
--  DDL for Index PRODUCT_NOTES_PK
- 
 
 669 
--------------------------------------------------------
- 
 
 670 
 
- 
 
 671 
  CREATE UNIQUE INDEX "PRODUCT_NOTES_PK" ON "PRODUCT_NOTES" ("PROD_ID")
- 
 
 672 
  ;
- 
 
 673 
/
- 
 
 674 
--------------------------------------------------------
- 
 
 675 
--  DDL for Index INX_OLD_BASE_ENV_ID
- 
 
 676 
--------------------------------------------------------
- 
 
 677 
 
- 
 
 678 
  CREATE INDEX "INX_OLD_BASE_ENV_ID" ON "BASE_ENV" ("OLD_BASE_ENV_ID")
- 
 
 679 
  ;
- 
 
 680 
/
- 
 
 681 
--------------------------------------------------------
- 
 
 682 
--  DDL for Index PK_DM_PROJECTS
- 
 
 683 
--------------------------------------------------------
- 
 
 684 
 
- 
 
 685 
  CREATE UNIQUE INDEX "PK_DM_PROJECTS" ON "DM_PROJECTS" ("PROJ_ID")
- 
 
 686 
  ;
- 
 
 687 
/
- 
 
 688 
--------------------------------------------------------
- 
 
 689 
--  DDL for Index INX_OLD_OS_ID
- 
 
 690 
--------------------------------------------------------
- 
 
 691 
 
- 
 
 692 
  CREATE INDEX "INX_OLD_OS_ID" ON "OPERATING_SYSTEMS" ("OLD_OS_ID")
- 
 
 693 
  ;
- 
 
 694 
/
- 
 
 695 
--------------------------------------------------------
- 
 
 696 
--  DDL for Index PK_NODE_TYPES
- 
 
 697 
--------------------------------------------------------
- 
 
 698 
 
- 
 
 699 
  CREATE UNIQUE INDEX "PK_NODE_TYPES" ON "NODE_TYPES" ("NODE_TYPE_ID")
- 
 
 700 
  ;
- 
 
 701 
/
- 
 
 702 
--------------------------------------------------------
- 
 
 703 
--  DDL for Index PK_DEF_ACTION_BUTTONS
- 
 
 704 
--------------------------------------------------------
- 
 
 705 
 
- 
 
 706 
  CREATE UNIQUE INDEX "PK_DEF_ACTION_BUTTONS" ON "DEF_ACTION_BUTTONS" ("ABTN_ID")
- 
 
 707 
  ;
- 
 
 708 
/
- 
 
 709 
--------------------------------------------------------
- 
 
 710 
--  DDL for Index UNQ_HARDWARE_NODE
- 
 
 711 
--------------------------------------------------------
- 
 
 712 
 
- 
 
 713 
  CREATE UNIQUE INDEX "UNQ_HARDWARE_NODE" ON "HARDWARE_NODE" ("HARDWARE_NAME_ID", "NODE_ID")
- 
 
 714 
  ;
- 
 
 715 
/
- 
 
 716 
--------------------------------------------------------
- 
 
 717 
--  DDL for Index PK_BASE_ENV
- 
 
 718 
--------------------------------------------------------
- 
 
 719 
 
- 
 
 720 
  CREATE UNIQUE INDEX "PK_BASE_ENV" ON "BASE_ENV" ("BASE_ENV_ID")
- 
 
 721 
  ;
- 
 
 722 
/
- 
 
 723 
--------------------------------------------------------
- 
 
 724 
--  DDL for Index UNQ_HARDWARE
- 
 
 725 
--------------------------------------------------------
- 
 
 726 
 
- 
 
 727 
  CREATE UNIQUE INDEX "UNQ_HARDWARE" ON "HARDWARE" ("BOM_ID", "HARDWARE_NAME")
- 
 
 728 
  ;
- 
 
 729 
/
- 
 
 730 
--------------------------------------------------------
- 
 
 731 
--  DDL for Index INX_KB_ARTICLE_DETAILS
- 
 
 732 
--------------------------------------------------------
- 
 
 733 
 
- 
 
 734 
  CREATE INDEX "INX_KB_ARTICLE_DETAILS" ON "KNOWLEDGE_BASE" ("ARTICLE_DETAILS")
- 
 
 735 
  ;
- 
 
 736 
/
- 
 
 737 
--------------------------------------------------------
- 
 
 738 
--  DDL for Index UNQ_OS_BASE_ENV
- 
 
 739 
--------------------------------------------------------
- 
 
 740 
 
- 
 
 741 
  CREATE UNIQUE INDEX "UNQ_OS_BASE_ENV" ON "OS_BASE_ENV" ("OS_ID", "BASE_ENV_ID")
- 
 
 742 
  ;
- 
 
 743 
/
- 
 
 744 
--------------------------------------------------------
- 
 
 745 
--  DDL for Index UNQ_BOS_TYPES
- 
 
 746 
--------------------------------------------------------
- 
 
 747 
 
- 
 
 748 
  CREATE UNIQUE INDEX "UNQ_BOS_TYPES" ON "BOS_TYPES" ("BOS_TYPE")
- 
 
 749 
  ;
- 
 
 750 
/
- 
 
 751 
--------------------------------------------------------
- 
 
 752 
--  DDL for Index INX_OS_NODE_ID
- 
 
 753 
--------------------------------------------------------
- 
 
 754 
 
- 
 
 755 
  CREATE INDEX "INX_OS_NODE_ID" ON "OPERATING_SYSTEMS" ("NODE_ID")
- 
 
 756 
  ;
- 
 
 757 
/
- 
 
 758 
--------------------------------------------------------
- 
 
 759 
--  DDL for Index INX_OLD_HARDWARE_NAME_ID
- 
 
 760 
--------------------------------------------------------
- 
 
 761 
 
- 
 
 762 
  CREATE INDEX "INX_OLD_HARDWARE_NAME_ID" ON "HARDWARE" ("OLD_HARDWARE_NAME_ID")
- 
 
 763 
  ;
- 
 
 764 
/
- 
 
 765 
--------------------------------------------------------
- 
 
 766 
--  DDL for Index INX_BOM_NOTES
- 
 
 767 
--------------------------------------------------------
- 
 
 768 
 
- 
 
 769 
  CREATE INDEX "INX_BOM_NOTES" ON "BOM_NOTES" ("BOM_ID", "BOM_SCOPE", "SCOPE_ID")
- 
 
 770 
  ;
- 
 
 771 
/
- 
 
 772 
--------------------------------------------------------
- 
 
 773 
--  DDL for Index INX_PC_PROC_ID
- 
 
 774 
--------------------------------------------------------
- 
 
 775 
 
- 
 
 776 
  CREATE INDEX "INX_PC_PROC_ID" ON "PROCESSES_CONFIG" ("PROC_ID")
- 
 
 777 
  ;
- 
 
 778 
/
- 
 
 779 
--------------------------------------------------------
- 
 
 780 
--  DDL for Index UNQ_NODE_TYPES
- 
 
 781 
--------------------------------------------------------
- 
 
 782 
 
- 
 
 783 
  CREATE UNIQUE INDEX "UNQ_NODE_TYPES" ON "NODE_TYPES" ("NODE_TYPE")
- 
 
 784 
  ;
- 
 
 785 
/
- 
 
 786 
--------------------------------------------------------
- 
 
 787 
--  DDL for Index UNQ_OS_CONTENTS
- 
 
 788 
--------------------------------------------------------
- 
 
 789 
 
- 
 
 790 
  CREATE UNIQUE INDEX "UNQ_OS_CONTENTS" ON "OS_CONTENTS" ("OS_ID", "PROD_ID")
- 
 
 791 
  ;
- 
 
 792 
/
- 
 
 793 
--------------------------------------------------------
- 
 
 794 
--  DDL for Index INX_BT_BOM_ID
- 
 
 795 
--------------------------------------------------------
- 
 
 796 
 
- 
 
 797 
  CREATE INDEX "INX_BT_BOM_ID" ON "BOM_TRAIL" ("BOM_ID")
- 
 
 798 
  ;
- 
 
 799 
/
- 
 
 800 
--------------------------------------------------------
- 
 
 801 
--  DDL for Index INX_BO_BOM_NAME_ID
- 
 
 802 
--------------------------------------------------------
- 
 
 803 
 
- 
 
 804 
  CREATE INDEX "INX_BO_BOM_NAME_ID" ON "BOMS" ("BOM_NAME_ID")
- 
 
 805 
  ;
- 
 
 806 
/
- 
 
 807 
--------------------------------------------------------
- 
 
 808 
--  DDL for Index INX_BO_BRANCH_ID
- 
 
 809 
--------------------------------------------------------
- 
 
 810 
 
- 
 
 811 
  CREATE INDEX "INX_BO_BRANCH_ID" ON "BOMS" ("BRANCH_ID")
- 
 
 812 
  ;
- 
 
 813 
/
- 
 
 814 
--------------------------------------------------------
- 
 
 815 
--  DDL for Index UNQ_POPUP_MENU_DEF
- 
 
 816 
--------------------------------------------------------
- 
 
 817 
 
- 
 
 818 
  CREATE UNIQUE INDEX "UNQ_POPUP_MENU_DEF" ON "DEF_MENU_ITEMS" ("ITEM_NAME")
- 
 
 819 
  ;
- 
 
 820 
/
- 
 
 821 
--------------------------------------------------------
- 
 
 822 
--  DDL for Index INX_PC_OS_ID
- 
 
 823 
--------------------------------------------------------
- 
 
 824 
 
- 
 
 825 
  CREATE INDEX "INX_PC_OS_ID" ON "PROCESSES_CONFIG" ("OS_ID")
- 
 
 826 
  ;
- 
 
 827 
/
- 
 
 828 
--------------------------------------------------------
- 
 
 829 
--  DDL for Index UNQ_ABTN_DEF
- 
 
 830 
--------------------------------------------------------
- 
 
 831 
 
- 
 
 832 
  CREATE UNIQUE INDEX "UNQ_ABTN_DEF" ON "DEF_ACTION_BUTTONS" ("ABTN_NAME")
- 
 
 833 
  ;
- 
 
 834 
/
- 
 
 835 
--------------------------------------------------------
- 
 
 836 
--  DDL for Index PK_NETWORK_NODES
- 
 
 837 
--------------------------------------------------------
- 
 
 838 
 
- 
 
 839 
  CREATE UNIQUE INDEX "PK_NETWORK_NODES" ON "NETWORK_NODES" ("NODE_ID")
- 
 
 840 
  ;
- 
 
 841 
/
- 
 
 842 
--------------------------------------------------------
- 
 
 843 
--  DDL for Index INX_BOM_NOTES_BOM_ID
- 
 
 844 
--------------------------------------------------------
- 
 
 845 
 
- 
 
 846 
  CREATE INDEX "INX_BOM_NOTES_BOM_ID" ON "BOM_NOTES" ("BOM_ID")
- 
 
 847 
  ;
- 
 
 848 
/
- 
 
 849 
--------------------------------------------------------
- 
 
 850 
--  DDL for Index INX_MSGBOARD
- 
 
 851 
--------------------------------------------------------
- 
 
 852 
 
- 
 
 853 
  CREATE INDEX "INX_MSGBOARD" ON "MESSAGE_BOARD" ("EXPIRY_DATE", "DUE_DATE")
- 
 
 854 
  ;
- 
 
 855 
/
- 
 
 856 
--------------------------------------------------------
- 
 
 857 
--  DDL for Index INX_OBE_OS_ID
- 
 
 858 
--------------------------------------------------------
- 
 
 859 
 
- 
 
 860 
  CREATE INDEX "INX_OBE_OS_ID" ON "OS_BASE_ENV" ("OS_ID")
- 
 
 861 
  ;
- 
 
 862 
/
- 
 
 863 
--------------------------------------------------------
- 
 
 864 
--  DDL for Index INX_HN_NODE_ID
- 
 
 865 
--------------------------------------------------------
- 
 
 866 
 
- 
 
 867 
  CREATE INDEX "INX_HN_NODE_ID" ON "HARDWARE_NODE" ("NODE_ID")
- 
 
 868 
  ;
- 
 
 869 
/
- 
 
 870 
--------------------------------------------------------
- 
 
 871 
--  DDL for Index INX_HN_HW_ID
- 
 
 872 
--------------------------------------------------------
- 
 
 873 
 
- 
 
 874 
  CREATE INDEX "INX_HN_HW_ID" ON "HARDWARE_NODE" ("HARDWARE_NAME_ID")
- 
 
 875 
  ;
- 
 
 876 
/
- 
 
 877 
--------------------------------------------------------
- 
 
 878 
--  DDL for Index INX_OLD_NODE_ID
- 
 
 879 
--------------------------------------------------------
- 
 
 880 
 
- 
 
 881 
  CREATE INDEX "INX_OLD_NODE_ID" ON "NETWORK_NODES" ("OLD_NODE_ID")
- 
 
 882 
  ;
- 
 
 883 
/
- 
 
 884 
--------------------------------------------------------
- 
 
 885 
--  DDL for Index UNQ_PROC_CONFIG
- 
 
 886 
--------------------------------------------------------
- 
 
 887 
 
- 
 
 888 
  CREATE INDEX "UNQ_PROC_CONFIG" ON "PROCESSES_CONFIG" ("PROD_ID", "OS_ID", "PKG_HEALTH_TAG")
- 
 
 889 
  ;
- 
 
 890 
/
- 
 
 891 
--------------------------------------------------------
- 
 
 892 
--  DDL for Index INX_HARDWARE_BOM_ID
- 
 
 893 
--------------------------------------------------------
- 
 
 894 
 
- 
 
 895 
  CREATE INDEX "INX_HARDWARE_BOM_ID" ON "HARDWARE" ("BOM_ID")
- 
 
 896 
  ;
- 
 
 897 
/
- 
 
 898 
--------------------------------------------------------
- 
 
 899 
--  DDL for Index INX_BO_BOM_VERSION
- 
 
 900 
--------------------------------------------------------
- 
 
 901 
 
- 
 
 902 
  CREATE INDEX "INX_BO_BOM_VERSION" ON "BOMS" ("BOM_VERSION")
- 
 
 903 
  ;
- 
 
 904 
/
- 
 
 905 
--------------------------------------------------------
- 
 
 906 
--  DDL for Index UNQ_DM_PROJECTS
- 
 
 907 
--------------------------------------------------------
- 
 
 908 
 
- 
 
 909 
  CREATE UNIQUE INDEX "UNQ_DM_PROJECTS" ON "DM_PROJECTS" ("PROJ_NAME")
- 
 
 910 
  ;
- 
 
 911 
/
- 
 
 912 
--------------------------------------------------------
- 
 
 913 
--  DDL for Index PK_BOMS
- 
 
 914 
--------------------------------------------------------
- 
 
 915 
 
- 
 
 916 
  CREATE UNIQUE INDEX "PK_BOMS" ON "BOMS" ("BOM_ID")
- 
 
 917 
  ;
- 
 
 918 
/
- 
 
 919 
--------------------------------------------------------
- 
 
 920 
--  DDL for Index UNQ_BASE_ENV
- 
 
 921 
--------------------------------------------------------
- 
 
 922 
 
- 
 
 923 
  CREATE UNIQUE INDEX "UNQ_BASE_ENV" ON "BASE_ENV" ("BASE_ENV_NAME", "BOM_ID")
- 
 
 924 
  ;
- 
 
 925 
/
- 
 
 926 
--------------------------------------------------------
- 
 
 927 
--  DDL for Index INX_ST_PROJ_ID
- 
 
 928 
--------------------------------------------------------
- 
 
 929 
 
- 
 
 930 
  CREATE INDEX "INX_ST_PROJ_ID" ON "STATES" ("PROJ_ID")
- 
 
 931 
  ;
- 
 
 932 
/
- 
 
 933 
--------------------------------------------------------
- 
 
 934 
--  DDL for Index PK_BRANCHES
- 
 
 935 
--------------------------------------------------------
- 
 
 936 
 
- 
 
 937 
  CREATE UNIQUE INDEX "PK_BRANCHES" ON "BRANCHES" ("BRANCH_ID")
- 
 
 938 
  ;
- 
 
 939 
/
- 
 
 940 
--------------------------------------------------------
- 
 
 941 
--  DDL for Index UNQ_VALIDATION_RULES
- 
 
 942 
--------------------------------------------------------
- 
 
 943 
 
- 
 
 944 
  CREATE UNIQUE INDEX "UNQ_VALIDATION_RULES" ON "VALIDATION_RULES" ("FIELD_NAME")
- 
 
 945 
  ;
- 
 
 946 
/
- 
 
 947 
--------------------------------------------------------
- 
 
 948 
--  DDL for Index UNQ_BOM_NAMES
- 
 
 949 
--------------------------------------------------------
- 
 
 950 
 
- 
 
 951 
  CREATE UNIQUE INDEX "UNQ_BOM_NAMES" ON "BOM_NAMES" ("BOM_NAME")
- 
 
 952 
  ;
- 
 
 953 
/
- 
 
 954 
--------------------------------------------------------
- 
 
 955 
--  DDL for Index PK_DEF_MENU_ITEMS
- 
 
 956 
--------------------------------------------------------
- 
 
 957 
 
- 
 
 958 
  CREATE UNIQUE INDEX "PK_DEF_MENU_ITEMS" ON "DEF_MENU_ITEMS" ("ITEM_ID")
- 
 
 959 
  ;
- 
 
 960 
/
- 
 
 961 
--------------------------------------------------------
- 
 
 962 
--  DDL for Index UNQ_STATES
- 
 
 963 
--------------------------------------------------------
- 
 
 964 
 
- 
 
 965 
  CREATE UNIQUE INDEX "UNQ_STATES" ON "STATES" ("PROJ_ID", "STATE_NAME")
- 
 
 966 
  ;
- 
 
 967 
/
- 
 
 968 
--------------------------------------------------------
- 
 
 969 
--  DDL for Index PK_STATES
- 
 
 970 
--------------------------------------------------------
- 
 
 971 
 
- 
 
 972 
  CREATE UNIQUE INDEX "PK_STATES" ON "STATES" ("STATE_ID")
- 
 
 973 
  ;
- 
 
 974 
/
- 
 
 975 
--------------------------------------------------------
- 
 
 976 
--  DDL for Index INX_BR_PROJ_ID
- 
 
 977 
--------------------------------------------------------
- 
 
 978 
 
- 
 
 979 
  CREATE INDEX "INX_BR_PROJ_ID" ON "BRANCHES" ("PROJ_ID")
- 
 
 980 
  ;
- 
 
 981 
/
- 
 
 982 
--------------------------------------------------------
- 
 
 983 
--  DDL for Index INX_OSC_PROD_ID
- 
 
 984 
--------------------------------------------------------
- 
 
 985 
 
- 
 
 986 
  CREATE INDEX "INX_OSC_PROD_ID" ON "OS_CONTENTS" ("PROD_ID")
- 
 
 987 
  ;
- 
 
 988 
/
- 
 
 989 
--------------------------------------------------------
- 
 
 990 
--  DDL for Index PKSYSTEM_CONFIGURATION1
- 
 
 991 
--------------------------------------------------------
- 
 
 992 
 
- 
 
 993 
  CREATE UNIQUE INDEX "PKSYSTEM_CONFIGURATION1" ON "SYSTEM_CONFIGURATION" ("ITEM_NAME")
- 
 
 994 
  ;
- 
 
 995 
/
- 
 
 996 
--------------------------------------------------------
- 
 
 997 
--  DDL for Index UNQ_BASE_ENV_CONTS
- 
 
 998 
--------------------------------------------------------
- 
 
 999 
 
- 
 
 1000 
  CREATE UNIQUE INDEX "UNQ_BASE_ENV_CONTS" ON "BASE_ENV_CONTENTS" ("BASE_ENV_ID", "PROD_ID")
- 
 
 1001 
  ;
- 
 
 1002 
/
- 
 
 1003 
--------------------------------------------------------
- 
 
 1004 
--  DDL for Index UNQ_BOM_STATE
- 
 
 1005 
--------------------------------------------------------
- 
 
 1006 
 
- 
 
 1007 
  CREATE UNIQUE INDEX "UNQ_BOM_STATE" ON "BOM_STATE" ("BOM_ID", "STATE_ID")
- 
 
 1008 
  ;
- 
 
 1009 
/
- 
 
 1010 
--------------------------------------------------------
- 
 
 1011 
--  DDL for Index PK_KNOWLEDGE_BASE
- 
 
 1012 
--------------------------------------------------------
- 
 
 1013 
 
- 
 
 1014 
  CREATE UNIQUE INDEX "PK_KNOWLEDGE_BASE" ON "KNOWLEDGE_BASE" ("ARTICLE_ID")
- 
 
 1015 
  ;
- 
 
 1016 
/
- 
 
 1017 
--------------------------------------------------------
- 
 
 1018 
--  DDL for Index UNQ_RELATED_ARTICLES
- 
 
 1019 
--------------------------------------------------------
- 
 
 1020 
 
- 
 
 1021 
  CREATE UNIQUE INDEX "UNQ_RELATED_ARTICLES" ON "RELATED_ARTICLES" ("ARTICLE_ID", "RARTICLE_ID")
- 
 
 1022 
  ;
- 
 
 1023 
/
- 
 
 1024 
--------------------------------------------------------
- 
 
 1025 
--  DDL for Index INX_BS_BOM_ID
- 
 
 1026 
--------------------------------------------------------
- 
 
 1027 
 
- 
 
 1028 
  CREATE INDEX "INX_BS_BOM_ID" ON "BOM_STATE" ("BOM_ID")
- 
 
 1029 
  ;
- 
 
 1030 
/
- 
 
 1031 
--------------------------------------------------------
- 
 
 1032 
--  DDL for Index INX_PC_PROD_ID
- 
 
 1033 
--------------------------------------------------------
- 
 
 1034 
 
- 
 
 1035 
  CREATE INDEX "INX_PC_PROD_ID" ON "PROCESSES_CONFIG" ("PROD_ID")
- 
 
 1036 
  ;
- 
 
 1037 
/
- 
 
 1038 
--------------------------------------------------------
- 
 
 1039 
--  DDL for Index INX_BEC_BASE_ENV_ID
- 
 
 1040 
--------------------------------------------------------
- 
 
 1041 
 
- 
 
 1042 
  CREATE INDEX "INX_BEC_BASE_ENV_ID" ON "BASE_ENV_CONTENTS" ("BASE_ENV_ID")
- 
 
 1043 
  ;
- 
 
 1044 
/
- 
 
 1045 
--------------------------------------------------------
- 
 
 1046 
--  DDL for Index INX_OBE_BASE_ENV_ID
- 
 
 1047 
--------------------------------------------------------
- 
 
 1048 
 
- 
 
 1049 
  CREATE INDEX "INX_OBE_BASE_ENV_ID" ON "OS_BASE_ENV" ("BASE_ENV_ID")
- 
 
 1050 
  ;
- 
 
 1051 
/
- 
 
 1052 
--------------------------------------------------------
- 
 
 1053 
--  DDL for Index UNQ_BOM_CONTENTS
- 
 
 1054 
--------------------------------------------------------
- 
 
 1055 
 
- 
 
 1056 
  CREATE UNIQUE INDEX "UNQ_BOM_CONTENTS" ON "BOM_CONTENTS" ("BOM_ID", "NODE_ID")
- 
 
 1057 
  ;
- 
 
 1058 
/
- 
 
 1059 
--------------------------------------------------------
- 
 
 1060 
--  DDL for Index INX_BO_OLD_BOM_ID
- 
 
 1061 
--------------------------------------------------------
- 
 
 1062 
 
- 
 
 1063 
  CREATE INDEX "INX_BO_OLD_BOM_ID" ON "BOMS" ("OLD_BOM_ID")
- 
 
 1064 
  ;
- 
 
 1065 
/
- 
 
 1066 
--------------------------------------------------------
- 
 
 1067 
--  DDL for Index UNQ_OPERATING_SYSTEMS
- 
 
 1068 
--------------------------------------------------------
- 
 
 1069 
 
- 
 
 1070 
  CREATE UNIQUE INDEX "UNQ_OPERATING_SYSTEMS" ON "OPERATING_SYSTEMS" ("OS_NAME", "NODE_ID")
- 
 
 1071 
  ;
- 
 
 1072 
/
- 
 
 1073 
--------------------------------------------------------
- 
 
 1074 
--  DDL for Index PK_MESSAGE_BOARD
- 
 
 1075 
--------------------------------------------------------
- 
 
 1076 
 
- 
 
 1077 
  CREATE UNIQUE INDEX "PK_MESSAGE_BOARD" ON "MESSAGE_BOARD" ("MSG_ID")
- 
 
 1078 
  ;
- 
 
 1079 
/
- 
 
 1080 
--------------------------------------------------------
- 
 
 1081 
--  DDL for Index INX_KB_MOD_STAMP
- 
 
 1082 
--------------------------------------------------------
- 
 
 1083 
 
- 
 
 1084 
  CREATE INDEX "INX_KB_MOD_STAMP" ON "KNOWLEDGE_BASE" ("MOD_STAMP")
- 
 
 1085 
  ;
- 
 
 1086 
/
- 
 
 1087 
--------------------------------------------------------
- 
 
 1088 
--  DDL for Index INX_BO_PARENT_BOM_ID
- 
 
 1089 
--------------------------------------------------------
- 
 
 1090 
 
- 
 
 1091 
  CREATE INDEX "INX_BO_PARENT_BOM_ID" ON "BOMS" ("PARENT_BOM_ID")
- 
 
 1092 
  ;
- 
 
 1093 
/
- 
 
 1094 
--------------------------------------------------------
- 
 
 1095 
--  DDL for Index INX_KB_ARTICLE_TITLE
- 
 
 1096 
--------------------------------------------------------
- 
 
 1097 
 
- 
 
 1098 
  CREATE INDEX "INX_KB_ARTICLE_TITLE" ON "KNOWLEDGE_BASE" ("ARTICLE_TITLE")
- 
 
 1099 
  ;
- 
 
 1100 
/
- 
 
 1101 
--------------------------------------------------------
- 
 
 1102 
--  DDL for Index UNQ_REJECTION_TRAIL
- 
 
 1103 
--------------------------------------------------------
- 
 
 1104 
 
- 
 
 1105 
  CREATE UNIQUE INDEX "UNQ_REJECTION_TRAIL" ON "REJECTION_TRAIL" ("ENUM_ENTITY_TYPE", "ENTITY_ID", "REJECT_SEQ")
- 
 
 1106 
  ;
- 
 
 1107 
/
- 
 
 1108 
--------------------------------------------------------
- 
 
 1109 
--  DDL for Index PK_OPERATING_SYSTEMS
- 
 
 1110 
--------------------------------------------------------
- 
 
 1111 
 
- 
 
 1112 
  CREATE UNIQUE INDEX "PK_OPERATING_SYSTEMS" ON "OPERATING_SYSTEMS" ("OS_ID")
- 
 
 1113 
  ;
- 
 
 1114 
/
- 
 
 1115 
--------------------------------------------------------
- 
 
 1116 
--  DDL for Index PK_BOM_NAMES
- 
 
 1117 
--------------------------------------------------------
- 
 
 1118 
 
- 
 
 1119 
  CREATE UNIQUE INDEX "PK_BOM_NAMES" ON "BOM_NAMES" ("BOM_NAME_ID")
- 
 
 1120 
  ;
- 
 
 1121 
/
- 
 
 1122 
--------------------------------------------------------
- 
 
 1123 
--  DDL for Index PKPRODUCT_DETAILS
- 
 
 1124 
--------------------------------------------------------
- 
 
 1125 
 
- 
 
 1126 
  CREATE UNIQUE INDEX "PKPRODUCT_DETAILS" ON "PRODUCT_DETAILS" ("PROD_ID")
- 
 
 1127 
  ;
- 
 
 1128 
/
- 
 
 1129 
--------------------------------------------------------
- 
 
 1130 
--  DDL for Index INX_ACTION_TRAIL
- 
 
 1131 
--------------------------------------------------------
- 
 
 1132 
 
- 
 
 1133 
  CREATE INDEX "INX_ACTION_TRAIL" ON "ACTION_TRAIL" ("ACTION_STAMP", "USER_ID", "ACTION_EVENT")
- 
 
 1134 
  ;
- 
 
 1135 
/
- 
 
 1136 
--------------------------------------------------------
- 
 
 1137 
--  DDL for Index PK_HARDWARE
- 
 
 1138 
--------------------------------------------------------
- 
 
 1139 
 
- 
 
 1140 
  CREATE UNIQUE INDEX "PK_HARDWARE" ON "HARDWARE" ("HARDWARE_NAME_ID")
- 
 
 1141 
  ;
- 
 
 1142 
/
- 
 
 1143 
--------------------------------------------------------
- 
 
 1144 
--  DDL for Index INX_OSC_OS_ID
- 
 
 1145 
--------------------------------------------------------
- 
 
 1146 
 
- 
 
 1147 
  CREATE INDEX "INX_OSC_OS_ID" ON "OS_CONTENTS" ("OS_ID")
- 
 
 1148 
  ;
- 
 
 1149 
/
- 
 
 1150 
--------------------------------------------------------
- 
 
 1151 
--  DDL for Index INX_BO_BOM_LIFECYCLE
- 
 
 1152 
--------------------------------------------------------
- 
 
 1153 
 
- 
 
 1154 
  CREATE INDEX "INX_BO_BOM_LIFECYCLE" ON "BOMS" ("BOM_LIFECYCLE")
- 
 
 1155 
  ;
- 
 
 1156 
/
- 
 
 1157 
--------------------------------------------------------
- 
 
 1158 
--  DDL for Index UNQ_BRANCHES
- 
 
 1159 
--------------------------------------------------------
- 
 
 1160 
 
- 
 
 1161 
  CREATE UNIQUE INDEX "UNQ_BRANCHES" ON "BRANCHES" ("PROJ_ID", "BRANCH_NAME")
- 
 
 1162 
  ;
- 
 
 1163 
/
- 
 
 1164 
--------------------------------------------------------
- 
 
 1165 
--  Constraints for Table HIDE_PRODUCTS
- 
 
 1166 
--------------------------------------------------------
- 
 
 1167 
 
- 
 
 1168 
  ALTER TABLE "HIDE_PRODUCTS" MODIFY ("PROD_ID" NOT NULL ENABLE);
- 
 
 1169 
  ALTER TABLE "HIDE_PRODUCTS" MODIFY ("OS_ID" NOT NULL ENABLE);
- 
 
 1170 
/
- 
 
 1171 
--------------------------------------------------------
- 
 
 1172 
--  Constraints for Table BASE_ENV
- 
 
 1173 
--------------------------------------------------------
- 
 
 1174 
 
- 
 
 1175 
  ALTER TABLE "BASE_ENV" ADD CONSTRAINT "PK_BASE_ENV" PRIMARY KEY ("BASE_ENV_ID") ENABLE;
- 
 
 1176 
  ALTER TABLE "BASE_ENV" MODIFY ("BOM_ID" NOT NULL ENABLE);
- 
 
 1177 
  ALTER TABLE "BASE_ENV" MODIFY ("BASE_ENV_NAME" NOT NULL ENABLE);
- 
 
 1178 
  ALTER TABLE "BASE_ENV" MODIFY ("BOS_ID" NOT NULL ENABLE);
- 
 
 1179 
  ALTER TABLE "BASE_ENV" MODIFY ("BASE_ENV_ID" NOT NULL ENABLE);
- 
 
 1180 
/
- 
 
 1181 
--------------------------------------------------------
- 
 
 1182 
--  Constraints for Table OS_CONTENTS
- 
 
 1183 
--------------------------------------------------------
- 
 
 1184 
 
- 
 
 1185 
  ALTER TABLE "OS_CONTENTS" MODIFY ("PROD_ID" NOT NULL ENABLE);
- 
 
 1186 
  ALTER TABLE "OS_CONTENTS" MODIFY ("SEQ_NUM" NOT NULL ENABLE);
- 
 
 1187 
  ALTER TABLE "OS_CONTENTS" MODIFY ("OS_ID" NOT NULL ENABLE);
- 
 
 1188 
/
- 
 
 1189 
--------------------------------------------------------
- 
 
 1190 
--  Constraints for Table BOM_NAMES
- 
 
 1191 
--------------------------------------------------------
- 
 
 1192 
 
- 
 
 1193 
  ALTER TABLE "BOM_NAMES" ADD CONSTRAINT "PK_BOM_NAMES" PRIMARY KEY ("BOM_NAME_ID") ENABLE;
- 
 
 1194 
  ALTER TABLE "BOM_NAMES" MODIFY ("BOM_NAME" NOT NULL ENABLE);
- 
 
 1195 
  ALTER TABLE "BOM_NAMES" MODIFY ("BOM_NAME_ID" NOT NULL ENABLE);
- 
 
 1196 
/
- 
 
 1197 
--------------------------------------------------------
- 
 
 1198 
--  Constraints for Table UNIT_TESTS
- 
 
 1199 
--------------------------------------------------------
- 
 
 1200 
 
- 
 
 1201 
  ALTER TABLE "UNIT_TESTS" MODIFY ("TEST_TYPES_FK" NOT NULL ENABLE);
- 
 
 1202 
  ALTER TABLE "UNIT_TESTS" MODIFY ("PV_ID" NOT NULL ENABLE);
- 
 
 1203 
  ALTER TABLE "UNIT_TESTS" MODIFY ("TEST_ID" NOT NULL ENABLE);
- 
 
 1204 
/
- 
 
 1205 
--------------------------------------------------------
- 
 
 1206 
--  Constraints for Table SYSTEM_CONFIGURATION
- 
 
 1207 
--------------------------------------------------------
- 
 
 1208 
 
- 
 
 1209 
  ALTER TABLE "SYSTEM_CONFIGURATION" ADD CONSTRAINT "PKSYSTEM_CONFIGURATION1" PRIMARY KEY ("ITEM_NAME") ENABLE;
- 
 
 1210 
  ALTER TABLE "SYSTEM_CONFIGURATION" MODIFY ("ITEM_NAME" NOT NULL ENABLE);
- 
 
 1211 
/
- 
 
 1212 
--------------------------------------------------------
- 
 
 1213 
--  Constraints for Table PACKAGE_TRAIL
- 
 
 1214 
--------------------------------------------------------
- 
 
 1215 
 
- 
 
 1216 
  ALTER TABLE "PACKAGE_TRAIL" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
- 
 
 1217 
  ALTER TABLE "PACKAGE_TRAIL" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 1218 
  ALTER TABLE "PACKAGE_TRAIL" MODIFY ("TRAIL_ACTION" NOT NULL ENABLE);
- 
 
 1219 
  ALTER TABLE "PACKAGE_TRAIL" MODIFY ("PKG_ID" NOT NULL ENABLE);
- 
 
 1220 
/
- 
 
 1221 
--------------------------------------------------------
- 
 
 1222 
--  Constraints for Table OS_TRAIL
- 
 
 1223 
--------------------------------------------------------
- 
 
 1224 
 
- 
 
 1225 
  ALTER TABLE "OS_TRAIL" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
- 
 
 1226 
  ALTER TABLE "OS_TRAIL" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 1227 
/
- 
 
 1228 
--------------------------------------------------------
- 
 
 1229 
--  Constraints for Table BOS_TYPES
- 
 
 1230 
--------------------------------------------------------
- 
 
 1231 
 
- 
 
 1232 
  ALTER TABLE "BOS_TYPES" ADD CONSTRAINT "PK_BOS_TYPES" PRIMARY KEY ("BOS_ID") ENABLE;
- 
 
 1233 
  ALTER TABLE "BOS_TYPES" MODIFY ("BOS_ICON" NOT NULL ENABLE);
- 
 
 1234 
  ALTER TABLE "BOS_TYPES" MODIFY ("BOS_TYPE" NOT NULL ENABLE);
- 
 
 1235 
  ALTER TABLE "BOS_TYPES" MODIFY ("BOS_ID" NOT NULL ENABLE);
- 
 
 1236 
/
- 
 
 1237 
--------------------------------------------------------
- 
 
 1238 
--  Constraints for Table MESSAGE_BOARD
- 
 
 1239 
--------------------------------------------------------
- 
 
 1240 
 
- 
 
 1241 
  ALTER TABLE "MESSAGE_BOARD" MODIFY ("SUBMITION_DATE" NOT NULL ENABLE);
- 
 
 1242 
  ALTER TABLE "MESSAGE_BOARD" MODIFY ("MSG_DETAILS" NOT NULL ENABLE);
- 
 
 1243 
  ALTER TABLE "MESSAGE_BOARD" MODIFY ("MSG_ID" NOT NULL ENABLE);
- 
 
 1244 
/
- 
 
 1245 
--------------------------------------------------------
- 
 
 1246 
--  Constraints for Table HARDWARE
- 
 
 1247 
--------------------------------------------------------
- 
 
 1248 
 
- 
 
 1249 
  ALTER TABLE "HARDWARE" ADD CONSTRAINT "PK_HARDWARE" PRIMARY KEY ("HARDWARE_NAME_ID") ENABLE;
- 
 
 1250 
  ALTER TABLE "HARDWARE" MODIFY ("HARDWARE_NAME" NOT NULL ENABLE);
- 
 
 1251 
  ALTER TABLE "HARDWARE" MODIFY ("BOM_ID" NOT NULL ENABLE);
- 
 
 1252 
  ALTER TABLE "HARDWARE" MODIFY ("HARDWARE_NAME_ID" NOT NULL ENABLE);
- 
 
 1253 
/
- 
 
 1254 
--------------------------------------------------------
- 
 
 1255 
--  Constraints for Table BOMS
- 
 
 1256 
--------------------------------------------------------
- 
 
 1257 
 
- 
 
 1258 
  ALTER TABLE "BOMS" ADD CONSTRAINT "PK_BOMS" PRIMARY KEY ("BOM_ID") ENABLE;
- 
 
 1259 
  ALTER TABLE "BOMS" MODIFY ("PARENT_BOM_ID" NOT NULL ENABLE);
- 
 
 1260 
  ALTER TABLE "BOMS" MODIFY ("BOM_LIFECYCLE" NOT NULL ENABLE);
- 
 
 1261 
  ALTER TABLE "BOMS" MODIFY ("IS_HIDDEN" NOT NULL ENABLE);
- 
 
 1262 
  ALTER TABLE "BOMS" MODIFY ("IS_READONLY" NOT NULL ENABLE);
- 
 
 1263 
  ALTER TABLE "BOMS" MODIFY ("BOM_VERSION" NOT NULL ENABLE);
- 
 
 1264 
  ALTER TABLE "BOMS" MODIFY ("BOM_NAME_ID" NOT NULL ENABLE);
- 
 
 1265 
  ALTER TABLE "BOMS" MODIFY ("BRANCH_ID" NOT NULL ENABLE);
- 
 
 1266 
  ALTER TABLE "BOMS" MODIFY ("BOM_ID" NOT NULL ENABLE);
- 
 
 1267 
/
- 
 
 1268 
--------------------------------------------------------
- 
 
 1269 
--  Constraints for Table STATES
- 
 
 1270 
--------------------------------------------------------
- 
 
 1271 
 
- 
 
 1272 
  ALTER TABLE "STATES" ADD CONSTRAINT "PK_STATES" PRIMARY KEY ("STATE_ID") ENABLE;
- 
 
 1273 
  ALTER TABLE "STATES" MODIFY ("STATE_TYPE_ENUM" NOT NULL ENABLE);
- 
 
 1274 
  ALTER TABLE "STATES" MODIFY ("STATE_SEQ" NOT NULL ENABLE);
- 
 
 1275 
  ALTER TABLE "STATES" MODIFY ("STATE_NAME" NOT NULL ENABLE);
- 
 
 1276 
  ALTER TABLE "STATES" MODIFY ("PROJ_ID" NOT NULL ENABLE);
- 
 
 1277 
  ALTER TABLE "STATES" MODIFY ("STATE_ID" NOT NULL ENABLE);
- 
 
 1278 
/
- 
 
 1279 
--------------------------------------------------------
- 
 
 1280 
--  Constraints for Table NODE_TYPES
- 
 
 1281 
--------------------------------------------------------
- 
 
 1282 
 
- 
 
 1283 
  ALTER TABLE "NODE_TYPES" ADD CONSTRAINT "PK_NODE_TYPES" PRIMARY KEY ("NODE_TYPE_ID") ENABLE;
- 
 
 1284 
  ALTER TABLE "NODE_TYPES" MODIFY ("NODE_IMAGE" NOT NULL ENABLE);
- 
 
 1285 
  ALTER TABLE "NODE_TYPES" MODIFY ("NODE_ICON" NOT NULL ENABLE);
- 
 
 1286 
  ALTER TABLE "NODE_TYPES" MODIFY ("NODE_TYPE" NOT NULL ENABLE);
- 
 
 1287 
  ALTER TABLE "NODE_TYPES" MODIFY ("NODE_TYPE_ID" NOT NULL ENABLE);
- 
 
 1288 
/
- 
 
 1289 
--------------------------------------------------------
- 
 
 1290 
--  Constraints for Table BOM_STATE
- 
 
 1291 
--------------------------------------------------------
- 
 
 1292 
 
- 
 
 1293 
  ALTER TABLE "BOM_STATE" MODIFY ("IS_DISPLAYED" NOT NULL ENABLE);
- 
 
 1294 
  ALTER TABLE "BOM_STATE" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 1295 
  ALTER TABLE "BOM_STATE" MODIFY ("STATE_ID" NOT NULL ENABLE);
- 
 
 1296 
  ALTER TABLE "BOM_STATE" MODIFY ("BOM_ID" NOT NULL ENABLE);
- 
 
 1297 
/
- 
 
 1298 
--------------------------------------------------------
- 
 
 1299 
--  Constraints for Table HARDWARE_NODE
- 
 
 1300 
--------------------------------------------------------
- 
 
 1301 
 
- 
 
 1302 
  ALTER TABLE "HARDWARE_NODE" MODIFY ("NODE_ID" NOT NULL ENABLE);
- 
 
 1303 
  ALTER TABLE "HARDWARE_NODE" MODIFY ("HARDWARE_NAME_ID" NOT NULL ENABLE);
- 
 
 1304 
/
- 
 
 1305 
--------------------------------------------------------
- 
 
 1306 
--  Constraints for Table NODE_TRAIL
- 
 
 1307 
--------------------------------------------------------
- 
 
 1308 
 
- 
 
 1309 
  ALTER TABLE "NODE_TRAIL" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
- 
 
 1310 
  ALTER TABLE "NODE_TRAIL" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 1311 
  ALTER TABLE "NODE_TRAIL" MODIFY ("NODE_ID" NOT NULL ENABLE);
- 
 
 1312 
/
- 
 
 1313 
--------------------------------------------------------
- 
 
 1314 
--  Constraints for Table PRODUCTS_QUEUE
- 
 
 1315 
--------------------------------------------------------
- 
 
 1316 
 
- 
 
 1317 
  ALTER TABLE "PRODUCTS_QUEUE" MODIFY ("ARRIVAL_STAMP" NOT NULL ENABLE);
- 
 
 1318 
  ALTER TABLE "PRODUCTS_QUEUE" MODIFY ("PROD_ID" NOT NULL ENABLE);
- 
 
 1319 
  ALTER TABLE "PRODUCTS_QUEUE" MODIFY ("PROJ_ID" NOT NULL ENABLE);
- 
 
 1320 
/
- 
 
 1321 
--------------------------------------------------------
- 
 
 1322 
--  Constraints for Table DEF_ACTION_BUTTONS
- 
 
 1323 
--------------------------------------------------------
- 
 
 1324 
 
- 
 
 1325 
  ALTER TABLE "DEF_ACTION_BUTTONS" ADD CONSTRAINT "PK_DEF_ACTION_BUTTONS" PRIMARY KEY ("ABTN_ID") ENABLE;
- 
 
 1326 
  ALTER TABLE "DEF_ACTION_BUTTONS" MODIFY ("IS_READONLY_ACTION" NOT NULL ENABLE);
- 
 
 1327 
  ALTER TABLE "DEF_ACTION_BUTTONS" MODIFY ("ACTIVE" NOT NULL ENABLE);
- 
 
 1328 
  ALTER TABLE "DEF_ACTION_BUTTONS" MODIFY ("VISIBLE" NOT NULL ENABLE);
- 
 
 1329 
  ALTER TABLE "DEF_ACTION_BUTTONS" MODIFY ("ABTN_NAME" NOT NULL ENABLE);
- 
 
 1330 
  ALTER TABLE "DEF_ACTION_BUTTONS" MODIFY ("ABTN_ID" NOT NULL ENABLE);
- 
 
 1331 
/
- 
 
 1332 
--------------------------------------------------------
- 
 
 1333 
--  Constraints for Table KNOWLEDGE_BASE
- 
 
 1334 
--------------------------------------------------------
- 
 
 1335 
 
- 
 
 1336 
  ALTER TABLE "KNOWLEDGE_BASE" ADD CONSTRAINT "PK_KNOWLEDGE_BASE" PRIMARY KEY ("ARTICLE_ID") ENABLE;
- 
 
 1337 
  ALTER TABLE "KNOWLEDGE_BASE" MODIFY ("MODIFIER_ID" NOT NULL ENABLE);
- 
 
 1338 
  ALTER TABLE "KNOWLEDGE_BASE" MODIFY ("MOD_STAMP" NOT NULL ENABLE);
- 
 
 1339 
  ALTER TABLE "KNOWLEDGE_BASE" MODIFY ("CREATOR_ID" NOT NULL ENABLE);
- 
 
 1340 
  ALTER TABLE "KNOWLEDGE_BASE" MODIFY ("CREATED_STAMP" NOT NULL ENABLE);
- 
 
 1341 
  ALTER TABLE "KNOWLEDGE_BASE" MODIFY ("VISIBILITY_LEVEL_FK" NOT NULL ENABLE);
- 
 
 1342 
  ALTER TABLE "KNOWLEDGE_BASE" MODIFY ("ARTICLE_DETAILS" NOT NULL ENABLE);
- 
 
 1343 
  ALTER TABLE "KNOWLEDGE_BASE" MODIFY ("ARTICLE_TITLE" NOT NULL ENABLE);
- 
 
 1344 
  ALTER TABLE "KNOWLEDGE_BASE" MODIFY ("ARTICLE_ID" NOT NULL ENABLE);
- 
 
 1345 
/
- 
 
 1346 
--------------------------------------------------------
- 
 
 1347 
--  Constraints for Table BOM_TRAIL
- 
 
 1348 
--------------------------------------------------------
- 
 
 1349 
 
- 
 
 1350 
  ALTER TABLE "BOM_TRAIL" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
- 
 
 1351 
  ALTER TABLE "BOM_TRAIL" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 1352 
  ALTER TABLE "BOM_TRAIL" MODIFY ("TRAIL_ACTION" NOT NULL ENABLE);
- 
 
 1353 
  ALTER TABLE "BOM_TRAIL" MODIFY ("BOM_ID" NOT NULL ENABLE);
- 
 
 1354 
/
- 
 
 1355 
--------------------------------------------------------
- 
 
 1356 
--  Constraints for Table TEST_TYPES
- 
 
 1357 
--------------------------------------------------------
- 
 
 1358 
 
- 
 
 1359 
  ALTER TABLE "TEST_TYPES" ADD PRIMARY KEY ("TEST_TYPE_ID") ENABLE;
- 
 
 1360 
  ALTER TABLE "TEST_TYPES" MODIFY ("TEST_TYPE_NAME" NOT NULL ENABLE);
- 
 
 1361 
  ALTER TABLE "TEST_TYPES" MODIFY ("TEST_TYPE_ID" NOT NULL ENABLE);
- 
 
 1362 
/
- 
 
 1363 
--------------------------------------------------------
- 
 
 1364 
--  Constraints for Table PRODUCT_TRAIL
- 
 
 1365 
--------------------------------------------------------
- 
 
 1366 
 
- 
 
 1367 
  ALTER TABLE "PRODUCT_TRAIL" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
- 
 
 1368 
  ALTER TABLE "PRODUCT_TRAIL" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 1369 
/
- 
 
 1370 
--------------------------------------------------------
- 
 
 1371 
--  Constraints for Table BOM_STATE20100609
- 
 
 1372 
--------------------------------------------------------
- 
 
 1373 
 
- 
 
 1374 
  ALTER TABLE "BOM_STATE20100609" MODIFY ("IS_DISPLAYED" NOT NULL ENABLE);
- 
 
 1375 
  ALTER TABLE "BOM_STATE20100609" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 1376 
  ALTER TABLE "BOM_STATE20100609" MODIFY ("STATE_ID" NOT NULL ENABLE);
- 
 
 1377 
  ALTER TABLE "BOM_STATE20100609" MODIFY ("BOM_ID" NOT NULL ENABLE);
- 
 
 1378 
/
- 
 
 1379 
--------------------------------------------------------
- 
 
 1380 
--  Constraints for Table ACTION_TRAIL
- 
 
 1381 
--------------------------------------------------------
- 
 
 1382 
 
- 
 
 1383 
  ALTER TABLE "ACTION_TRAIL" MODIFY ("ACTION_EVENT" NOT NULL ENABLE);
- 
 
 1384 
  ALTER TABLE "ACTION_TRAIL" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 1385 
  ALTER TABLE "ACTION_TRAIL" MODIFY ("ACTION_STAMP" NOT NULL ENABLE);
- 
 
 1386 
/
- 
 
 1387 
--------------------------------------------------------
- 
 
 1388 
--  Constraints for Table PRODUCT_NOTES
- 
 
 1389 
--------------------------------------------------------
- 
 
 1390 
 
- 
 
 1391 
  ALTER TABLE "PRODUCT_NOTES" ADD CONSTRAINT "PRODUCT_NOTES_PK" PRIMARY KEY ("PROD_ID") ENABLE;
- 
 
 1392 
  ALTER TABLE "PRODUCT_NOTES" MODIFY ("PROD_ID" NOT NULL ENABLE);
- 
 
 1393 
/
- 
 
 1394 
--------------------------------------------------------
- 
 
 1395 
--  Constraints for Table OS_BASE_ENV
- 
 
 1396 
--------------------------------------------------------
- 
 
 1397 
 
- 
 
 1398 
  ALTER TABLE "OS_BASE_ENV" MODIFY ("BASE_ENV_ID" NOT NULL ENABLE);
- 
 
 1399 
  ALTER TABLE "OS_BASE_ENV" MODIFY ("OS_ID" NOT NULL ENABLE);
- 
 
 1400 
/
- 
 
 1401 
--------------------------------------------------------
- 
 
 1402 
--  Constraints for Table BASE_ENV_CONTENTS
- 
 
 1403 
--------------------------------------------------------
- 
 
 1404 
 
- 
 
 1405 
  ALTER TABLE "BASE_ENV_CONTENTS" MODIFY ("SEQ_NUM" NOT NULL ENABLE);
- 
 
 1406 
  ALTER TABLE "BASE_ENV_CONTENTS" MODIFY ("PROD_ID" NOT NULL ENABLE);
- 
 
 1407 
  ALTER TABLE "BASE_ENV_CONTENTS" MODIFY ("BASE_ENV_ID" NOT NULL ENABLE);
- 
 
 1408 
/
- 
 
 1409 
--------------------------------------------------------
- 
 
 1410 
--  Constraints for Table VALIDATION_RULES
- 
 
 1411 
--------------------------------------------------------
- 
 
 1412 
 
- 
 
 1413 
  ALTER TABLE "VALIDATION_RULES" MODIFY ("IS_REQUIRED" NOT NULL ENABLE);
- 
 
 1414 
  ALTER TABLE "VALIDATION_RULES" MODIFY ("FIELD_NAME" NOT NULL ENABLE);
- 
 
 1415 
/
- 
 
 1416 
--------------------------------------------------------
- 
 
 1417 
--  Constraints for Table NOTIFY_USER
- 
 
 1418 
--------------------------------------------------------
- 
 
 1419 
 
- 
 
 1420 
  ALTER TABLE "NOTIFY_USER" MODIFY ("EVENT_ENUM" NOT NULL ENABLE);
- 
 
 1421 
  ALTER TABLE "NOTIFY_USER" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 1422 
  ALTER TABLE "NOTIFY_USER" MODIFY ("PROJ_ID" NOT NULL ENABLE);
- 
 
 1423 
/
- 
 
 1424 
--------------------------------------------------------
- 
 
 1425 
--  Constraints for Table BOM_NOTES
- 
 
 1426 
--------------------------------------------------------
- 
 
 1427 
 
- 
 
 1428 
  ALTER TABLE "BOM_NOTES" MODIFY ("ARTICLE_ID" NOT NULL ENABLE);
- 
 
 1429 
  ALTER TABLE "BOM_NOTES" MODIFY ("SCOPE_ID" NOT NULL ENABLE);
- 
 
 1430 
  ALTER TABLE "BOM_NOTES" MODIFY ("BOM_SCOPE" NOT NULL ENABLE);
- 
 
 1431 
  ALTER TABLE "BOM_NOTES" MODIFY ("BOM_ID" NOT NULL ENABLE);
- 
 
 1432 
/
- 
 
 1433 
--------------------------------------------------------
- 
 
 1434 
--  Constraints for Table PRODUCTION_BOM
- 
 
 1435 
--------------------------------------------------------
- 
 
 1436 
 
- 
 
 1437 
  ALTER TABLE "PRODUCTION_BOM" MODIFY ("BOM_ID" NOT NULL ENABLE);
- 
 
 1438 
  ALTER TABLE "PRODUCTION_BOM" MODIFY ("PROJ_ID" NOT NULL ENABLE);
- 
 
 1439 
/
- 
 
 1440 
--------------------------------------------------------
- 
 
 1441 
--  Constraints for Table NETWORK_NODES
- 
 
 1442 
--------------------------------------------------------
- 
 
 1443 
 
- 
 
 1444 
  ALTER TABLE "NETWORK_NODES" ADD CONSTRAINT "PK_NETWORK_NODES" PRIMARY KEY ("NODE_ID") ENABLE;
- 
 
 1445 
  ALTER TABLE "NETWORK_NODES" MODIFY ("NODE_NAME" NOT NULL ENABLE);
- 
 
 1446 
  ALTER TABLE "NETWORK_NODES" MODIFY ("NODE_TYPE_ID" NOT NULL ENABLE);
- 
 
 1447 
  ALTER TABLE "NETWORK_NODES" MODIFY ("NODE_ID" NOT NULL ENABLE);
- 
 
 1448 
/
- 
 
 1449 
--------------------------------------------------------
- 
 
 1450 
--  Constraints for Table PRODUCT_DETAILS
- 
 
 1451 
--------------------------------------------------------
- 
 
 1452 
 
- 
 
 1453 
  ALTER TABLE "PRODUCT_DETAILS" ADD CONSTRAINT "PKPRODUCT_DETAILS" PRIMARY KEY ("PROD_ID") ENABLE;
- 
 
 1454 
  ALTER TABLE "PRODUCT_DETAILS" MODIFY ("PROD_ID" NOT NULL ENABLE);
- 
 
 1455 
/
- 
 
 1456 
--------------------------------------------------------
- 
 
 1457 
--  Constraints for Table DM_PROJECTS
- 
 
 1458 
--------------------------------------------------------
- 
 
 1459 
 
- 
 
 1460 
  ALTER TABLE "DM_PROJECTS" ADD CONSTRAINT "PK_DM_PROJECTS" PRIMARY KEY ("PROJ_ID") ENABLE;
- 
 
 1461 
  ALTER TABLE "DM_PROJECTS" MODIFY ("PROJ_NAME" NOT NULL ENABLE);
- 
 
 1462 
  ALTER TABLE "DM_PROJECTS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
- 
 
 1463 
/
- 
 
 1464 
--------------------------------------------------------
- 
 
 1465 
--  Constraints for Table BRANCHES
- 
 
 1466 
--------------------------------------------------------
- 
 
 1467 
 
- 
 
 1468 
  ALTER TABLE "BRANCHES" ADD CONSTRAINT "PK_BRANCHES" PRIMARY KEY ("BRANCH_ID") ENABLE;
- 
 
 1469 
  ALTER TABLE "BRANCHES" MODIFY ("BRANCH_NAME" NOT NULL ENABLE);
- 
 
 1470 
  ALTER TABLE "BRANCHES" MODIFY ("PROJ_ID" NOT NULL ENABLE);
- 
 
 1471 
  ALTER TABLE "BRANCHES" MODIFY ("BRANCH_ID" NOT NULL ENABLE);
- 
 
 1472 
/
- 
 
 1473 
--------------------------------------------------------
- 
 
 1474 
--  Constraints for Table BOM_CONTENTS
- 
 
 1475 
--------------------------------------------------------
- 
 
 1476 
 
- 
 
 1477 
  ALTER TABLE "BOM_CONTENTS" MODIFY ("NODE_ID" NOT NULL ENABLE);
- 
 
 1478 
  ALTER TABLE "BOM_CONTENTS" MODIFY ("BOM_ID" NOT NULL ENABLE);
- 
 
 1479 
/
- 
 
 1480 
--------------------------------------------------------
- 
 
 1481 
--  Constraints for Table REJECTION_TRAIL
- 
 
 1482 
--------------------------------------------------------
- 
 
 1483 
 
- 
 
 1484 
  ALTER TABLE "REJECTION_TRAIL" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 1485 
  ALTER TABLE "REJECTION_TRAIL" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
- 
 
 1486 
  ALTER TABLE "REJECTION_TRAIL" MODIFY ("REJECT_SEQ" NOT NULL ENABLE);
- 
 
 1487 
  ALTER TABLE "REJECTION_TRAIL" MODIFY ("ENTITY_ID" NOT NULL ENABLE);
- 
 
 1488 
  ALTER TABLE "REJECTION_TRAIL" MODIFY ("ENUM_ENTITY_TYPE" NOT NULL ENABLE);
- 
 
 1489 
/
- 
 
 1490 
--------------------------------------------------------
- 
 
 1491 
--  Constraints for Table RELATED_ARTICLES
- 
 
 1492 
--------------------------------------------------------
- 
 
 1493 
 
- 
 
 1494 
  ALTER TABLE "RELATED_ARTICLES" MODIFY ("RARTICLE_ID" NOT NULL ENABLE);
- 
 
 1495 
  ALTER TABLE "RELATED_ARTICLES" MODIFY ("ARTICLE_ID" NOT NULL ENABLE);
- 
 
 1496 
/
- 
 
 1497 
--------------------------------------------------------
- 
 
 1498 
--  Constraints for Table DEF_MENU_ITEMS
- 
 
 1499 
--------------------------------------------------------
- 
 
 1500 
 
- 
 
 1501 
  ALTER TABLE "DEF_MENU_ITEMS" ADD CONSTRAINT "PK_DEF_MENU_ITEMS" PRIMARY KEY ("ITEM_ID") ENABLE;
- 
 
 1502 
  ALTER TABLE "DEF_MENU_ITEMS" MODIFY ("ACTIVE" NOT NULL ENABLE);
- 
 
 1503 
  ALTER TABLE "DEF_MENU_ITEMS" MODIFY ("VISIBLE" NOT NULL ENABLE);
- 
 
 1504 
  ALTER TABLE "DEF_MENU_ITEMS" MODIFY ("ITEM_NAME" NOT NULL ENABLE);
- 
 
 1505 
  ALTER TABLE "DEF_MENU_ITEMS" MODIFY ("ITEM_ID" NOT NULL ENABLE);
- 
 
 1506 
/
- 
 
 1507 
--------------------------------------------------------
- 
 
 1508 
--  Constraints for Table PROCESSES_CONFIG
- 
 
 1509 
--------------------------------------------------------
- 
 
 1510 
 
- 
 
 1511 
  ALTER TABLE "PROCESSES_CONFIG" MODIFY ("PKG_ID" NOT NULL ENABLE);
- 
 
 1512 
  ALTER TABLE "PROCESSES_CONFIG" MODIFY ("PKG_HEALTH_TAG" NOT NULL ENABLE);
- 
 
 1513 
  ALTER TABLE "PROCESSES_CONFIG" MODIFY ("OS_ID" NOT NULL ENABLE);
- 
 
 1514 
  ALTER TABLE "PROCESSES_CONFIG" MODIFY ("PROD_ID" NOT NULL ENABLE);
- 
 
 1515 
/
- 
 
 1516 
--------------------------------------------------------
- 
 
 1517 
--  Constraints for Table RELEASE_AUTHORISATION
- 
 
 1518 
--------------------------------------------------------
- 
 
 1519 
 
- 
 
 1520 
  ALTER TABLE "RELEASE_AUTHORISATION" MODIFY ("TESTER_ID" NOT NULL ENABLE);
- 
 
 1521 
  ALTER TABLE "RELEASE_AUTHORISATION" MODIFY ("BOM_ID" NOT NULL ENABLE);
- 
 
 1522 
  ALTER TABLE "RELEASE_AUTHORISATION" MODIFY ("PV_ID" NOT NULL ENABLE);
- 
 
 1523 
/
- 
 
 1524 
--------------------------------------------------------
- 
 
 1525 
--  Constraints for Table OPERATING_SYSTEMS
- 
 
 1526 
--------------------------------------------------------
- 
 
 1527 
 
- 
 
 1528 
  ALTER TABLE "OPERATING_SYSTEMS" ADD CONSTRAINT "PK_OPERATING_SYSTEMS" PRIMARY KEY ("OS_ID") ENABLE;
- 
 
 1529 
  ALTER TABLE "OPERATING_SYSTEMS" MODIFY ("NODE_ID" NOT NULL ENABLE);
- 
 
 1530 
  ALTER TABLE "OPERATING_SYSTEMS" MODIFY ("OS_NAME" NOT NULL ENABLE);
- 
 
 1531 
  ALTER TABLE "OPERATING_SYSTEMS" MODIFY ("OS_ID" NOT NULL ENABLE);
- 
 
 1532 
/
- 
 
 1533 
--------------------------------------------------------
- 
 
 1534 
--  Ref Constraints for Table BASE_ENV
- 
 
 1535 
--------------------------------------------------------
- 
 
 1536 
 
- 
 
 1537 
  ALTER TABLE "BASE_ENV" ADD CONSTRAINT "FK_BASE_ENV_REF_BOMS" FOREIGN KEY ("BOM_ID")
- 
 
 1538 
	  REFERENCES "BOMS" ("BOM_ID") ENABLE;
- 
 
 1539 
  ALTER TABLE "BASE_ENV" ADD CONSTRAINT "FK_BASE_ENV_REF_BOS_TYPES" FOREIGN KEY ("BOS_ID")
- 
 
 1540 
	  REFERENCES "BOS_TYPES" ("BOS_ID") ENABLE;
- 
 
 1541 
/
- 
 
 1542 
--------------------------------------------------------
- 
 
 1543 
--  Ref Constraints for Table BASE_ENV_CONTENTS
- 
 
 1544 
--------------------------------------------------------
- 
 
 1545 
 
- 
 
 1546 
  ALTER TABLE "BASE_ENV_CONTENTS" ADD CONSTRAINT "FK_BASE_ENV_CONT_REF_BASE_ENV" FOREIGN KEY ("BASE_ENV_ID")
- 
 
 1547 
	  REFERENCES "BASE_ENV" ("BASE_ENV_ID") ENABLE;
- 
 
 1548 
/
- 
 
 1549 
--------------------------------------------------------
- 
 
 1550 
--  Ref Constraints for Table BOMS
- 
 
 1551 
--------------------------------------------------------
- 
 
 1552 
 
- 
 
 1553 
  ALTER TABLE "BOMS" ADD CONSTRAINT "FK_BOMS_REF_BOM_NAME" FOREIGN KEY ("BOM_NAME_ID")
- 
 
 1554 
	  REFERENCES "BOM_NAMES" ("BOM_NAME_ID") ENABLE;
- 
 
 1555 
  ALTER TABLE "BOMS" ADD CONSTRAINT "FK_BOMS_REF_BRANCHES" FOREIGN KEY ("BRANCH_ID")
- 
 
 1556 
	  REFERENCES "BRANCHES" ("BRANCH_ID") ENABLE;
- 
 
 1557 
/
- 
 
 1558 
--------------------------------------------------------
- 
 
 1559 
--  Ref Constraints for Table BOM_CONTENTS
- 
 
 1560 
--------------------------------------------------------
- 
 
 1561 
 
- 
 
 1562 
  ALTER TABLE "BOM_CONTENTS" ADD CONSTRAINT "FK_BOM_CONT_REF_BOMS" FOREIGN KEY ("BOM_ID")
- 
 
 1563 
	  REFERENCES "BOMS" ("BOM_ID") ENABLE;
- 
 
 1564 
  ALTER TABLE "BOM_CONTENTS" ADD CONSTRAINT "FK_BOM_CONT_REF_NETWORK" FOREIGN KEY ("NODE_ID")
- 
 
 1565 
	  REFERENCES "NETWORK_NODES" ("NODE_ID") ENABLE;
- 
 
 1566 
/
- 
 
 1567 
--------------------------------------------------------
- 
 
 1568 
--  Ref Constraints for Table BOM_NOTES
- 
 
 1569 
--------------------------------------------------------
- 
 
 1570 
 
- 
 
 1571 
  ALTER TABLE "BOM_NOTES" ADD CONSTRAINT "FK_BOM_NOTES_REF_BOMS" FOREIGN KEY ("BOM_ID")
- 
 
 1572 
	  REFERENCES "BOMS" ("BOM_ID") ENABLE;
- 
 
 1573 
  ALTER TABLE "BOM_NOTES" ADD CONSTRAINT "FK_BOM_NOTE_REF_HELP_NOTE" FOREIGN KEY ("ARTICLE_ID")
- 
 
 1574 
	  REFERENCES "KNOWLEDGE_BASE" ("ARTICLE_ID") ENABLE;
- 
 
 1575 
/
- 
 
 1576 
--------------------------------------------------------
- 
 
 1577 
--  Ref Constraints for Table BOM_STATE
- 
 
 1578 
--------------------------------------------------------
- 
 
 1579 
 
- 
 
 1580 
  ALTER TABLE "BOM_STATE" ADD CONSTRAINT "FK_BOM_STAT_REF_BOMS" FOREIGN KEY ("BOM_ID")
- 
 
 1581 
	  REFERENCES "BOMS" ("BOM_ID") ENABLE;
- 
 
 1582 
  ALTER TABLE "BOM_STATE" ADD CONSTRAINT "FK_BOM_STAT_REF_STATES" FOREIGN KEY ("STATE_ID")
- 
 
 1583 
	  REFERENCES "STATES" ("STATE_ID") ENABLE;
- 
 
 1584 
/
- 
 
 1585 
--------------------------------------------------------
- 
 
 1586 
--  Ref Constraints for Table BOM_TRAIL
- 
 
 1587 
--------------------------------------------------------
- 
 
 1588 
 
- 
 
 1589 
  ALTER TABLE "BOM_TRAIL" ADD CONSTRAINT "FK_BOM_TRAIL_REF_BOMS" FOREIGN KEY ("BOM_ID")
- 
 
 1590 
	  REFERENCES "BOMS" ("BOM_ID") ENABLE;
- 
 
 1591 
/
- 
 
 1592 
--------------------------------------------------------
- 
 
 1593 
--  Ref Constraints for Table BRANCHES
- 
 
 1594 
--------------------------------------------------------
- 
 
 1595 
 
- 
 
 1596 
  ALTER TABLE "BRANCHES" ADD CONSTRAINT "FK_BRANCHES_RE_DM_PROJ" FOREIGN KEY ("PROJ_ID")
- 
 
 1597 
	  REFERENCES "DM_PROJECTS" ("PROJ_ID") ENABLE;
- 
 
 1598 
/
- 
 
 1599 
--------------------------------------------------------
- 
 
 1600 
--  Ref Constraints for Table HARDWARE
- 
 
 1601 
--------------------------------------------------------
- 
 
 1602 
 
- 
 
 1603 
  ALTER TABLE "HARDWARE" ADD CONSTRAINT "FK_HARDWARE_REF_BOMS" FOREIGN KEY ("BOM_ID")
- 
 
 1604 
	  REFERENCES "BOMS" ("BOM_ID") ENABLE;
- 
 
 1605 
/
- 
 
 1606 
--------------------------------------------------------
- 
 
 1607 
--  Ref Constraints for Table HARDWARE_NODE
- 
 
 1608 
--------------------------------------------------------
- 
 
 1609 
 
- 
 
 1610 
  ALTER TABLE "HARDWARE_NODE" ADD CONSTRAINT "FK_HARDWARE_NODE_REF_HARDWARE" FOREIGN KEY ("HARDWARE_NAME_ID")
- 
 
 1611 
	  REFERENCES "HARDWARE" ("HARDWARE_NAME_ID") ENABLE;
- 
 
 1612 
  ALTER TABLE "HARDWARE_NODE" ADD CONSTRAINT "FK_HARDWARE_REF_NETWORK" FOREIGN KEY ("NODE_ID")
- 
 
 1613 
	  REFERENCES "NETWORK_NODES" ("NODE_ID") ENABLE;
- 
 
 1614 
/
- 
 
 1615 
--------------------------------------------------------
- 
 
 1616 
--  Ref Constraints for Table HIDE_PRODUCTS
- 
 
 1617 
--------------------------------------------------------
- 
 
 1618 
 
- 
 
 1619 
  ALTER TABLE "HIDE_PRODUCTS" ADD FOREIGN KEY ("OS_ID")
- 
 
 1620 
	  REFERENCES "OPERATING_SYSTEMS" ("OS_ID") DISABLE;
- 
 
 1621 
/
- 
 
 1622 
--------------------------------------------------------
- 
 
 1623 
--  Ref Constraints for Table NETWORK_NODES
- 
 
 1624 
--------------------------------------------------------
- 
 
 1625 
 
- 
 
 1626 
  ALTER TABLE "NETWORK_NODES" ADD CONSTRAINT "FK_NETWORK__REF_NODE_TYP" FOREIGN KEY ("NODE_TYPE_ID")
- 
 
 1627 
	  REFERENCES "NODE_TYPES" ("NODE_TYPE_ID") ENABLE;
- 
 
 1628 
/
- 
 
 1629 
--------------------------------------------------------
- 
 
 1630 
--  Ref Constraints for Table NOTIFY_USER
- 
 
 1631 
--------------------------------------------------------
- 
 
 1632 
 
- 
 
 1633 
  ALTER TABLE "NOTIFY_USER" ADD CONSTRAINT "FK_NOTIFY_USR_REFE_DM_PROJ" FOREIGN KEY ("PROJ_ID")
- 
 
 1634 
	  REFERENCES "DM_PROJECTS" ("PROJ_ID") ENABLE;
- 
 
 1635 
/
- 
 
 1636 
--------------------------------------------------------
- 
 
 1637 
--  Ref Constraints for Table OPERATING_SYSTEMS
- 
 
 1638 
--------------------------------------------------------
- 
 
 1639 
 
- 
 
 1640 
  ALTER TABLE "OPERATING_SYSTEMS" ADD CONSTRAINT "FK_OPERATIN_REF_NETWORK" FOREIGN KEY ("NODE_ID")
- 
 
 1641 
	  REFERENCES "NETWORK_NODES" ("NODE_ID") ENABLE;
- 
 
 1642 
/
- 
 
 1643 
--------------------------------------------------------
- 
 
 1644 
--  Ref Constraints for Table OS_BASE_ENV
- 
 
 1645 
--------------------------------------------------------
- 
 
 1646 
 
- 
 
 1647 
  ALTER TABLE "OS_BASE_ENV" ADD CONSTRAINT "FK_OS_BASE_ENV_REF_BASE_ENV" FOREIGN KEY ("BASE_ENV_ID")
- 
 
 1648 
	  REFERENCES "BASE_ENV" ("BASE_ENV_ID") ENABLE;
- 
 
 1649 
  ALTER TABLE "OS_BASE_ENV" ADD CONSTRAINT "FK_OS_BASE_ENV_REF_OS" FOREIGN KEY ("OS_ID")
- 
 
 1650 
	  REFERENCES "OPERATING_SYSTEMS" ("OS_ID") ENABLE;
- 
 
 1651 
/
- 
 
 1652 
--------------------------------------------------------
- 
 
 1653 
--  Ref Constraints for Table OS_CONTENTS
- 
 
 1654 
--------------------------------------------------------
- 
 
 1655 
 
- 
 
 1656 
  ALTER TABLE "OS_CONTENTS" ADD CONSTRAINT "FK_OS_CONTE_REF_OPERATIN" FOREIGN KEY ("OS_ID")
- 
 
 1657 
	  REFERENCES "OPERATING_SYSTEMS" ("OS_ID") ENABLE;
- 
 
 1658 
/
- 
 
 1659 
--------------------------------------------------------
- 
 
 1660 
--  Ref Constraints for Table PROCESSES_CONFIG
- 
 
 1661 
--------------------------------------------------------
- 
 
 1662 
 
- 
 
 1663 
  ALTER TABLE "PROCESSES_CONFIG" ADD CONSTRAINT "FK_PROC_CONFIG_REF_OS" FOREIGN KEY ("OS_ID")
- 
 
 1664 
	  REFERENCES "OPERATING_SYSTEMS" ("OS_ID") DISABLE;
- 
 
 1665 
/
- 
 
 1666 
--------------------------------------------------------
- 
 
 1667 
--  Ref Constraints for Table PRODUCTION_BOM
- 
 
 1668 
--------------------------------------------------------
- 
 
 1669 
 
- 
 
 1670 
  ALTER TABLE "PRODUCTION_BOM" ADD FOREIGN KEY ("PROJ_ID")
- 
 
 1671 
	  REFERENCES "DM_PROJECTS" ("PROJ_ID") ENABLE;
- 
 
 1672 
  ALTER TABLE "PRODUCTION_BOM" ADD FOREIGN KEY ("BOM_ID")
- 
 
 1673 
	  REFERENCES "BOMS" ("BOM_ID") ENABLE;
- 
 
 1674 
  ALTER TABLE "PRODUCTION_BOM" ADD FOREIGN KEY ("STATE_ID")
- 
 
 1675 
	  REFERENCES "STATES" ("STATE_ID") ENABLE;
- 
 
 1676 
/
- 
 
 1677 
--------------------------------------------------------
- 
 
 1678 
--  Ref Constraints for Table PRODUCTS_QUEUE
- 
 
 1679 
--------------------------------------------------------
- 
 
 1680 
 
- 
 
 1681 
  ALTER TABLE "PRODUCTS_QUEUE" ADD CONSTRAINT "FK_PRODUCTS_REFERENCE_DM_PROJE" FOREIGN KEY ("PRODQ_ID")
- 
 
 1682 
	  REFERENCES "DM_PROJECTS" ("PROJ_ID") ENABLE;
- 
 
 1683 
/
- 
 
 1684 
--------------------------------------------------------
- 
 
 1685 
--  Ref Constraints for Table RELATED_ARTICLES
- 
 
 1686 
--------------------------------------------------------
- 
 
 1687 
 
- 
 
 1688 
  ALTER TABLE "RELATED_ARTICLES" ADD CONSTRAINT "FK_RA_ARTID_REF_ARTID" FOREIGN KEY ("ARTICLE_ID")
- 
 
 1689 
	  REFERENCES "KNOWLEDGE_BASE" ("ARTICLE_ID") ENABLE;
- 
 
 1690 
  ALTER TABLE "RELATED_ARTICLES" ADD CONSTRAINT "FK_RA_RARTID_REF_ARTID" FOREIGN KEY ("RARTICLE_ID")
- 
 
 1691 
	  REFERENCES "KNOWLEDGE_BASE" ("ARTICLE_ID") ENABLE;
- 
 
 1692 
/
- 
 
 1693 
--------------------------------------------------------
- 
 
 1694 
--  Ref Constraints for Table RELEASE_AUTHORISATION
- 
 
 1695 
--------------------------------------------------------
- 
 
 1696 
 
- 
 
 1697 
  ALTER TABLE "RELEASE_AUTHORISATION" ADD CONSTRAINT "RELEASE_AUTHORISATION_R01" FOREIGN KEY ("BOM_ID")
- 
 
 1698 
	  REFERENCES "BOMS" ("BOM_ID") ENABLE;
- 
 
 1699 
/
- 
 
 1700 
--------------------------------------------------------
- 
 
 1701 
--  Ref Constraints for Table STATES
- 
 
 1702 
--------------------------------------------------------
- 
 
 1703 
 
- 
 
 1704 
  ALTER TABLE "STATES" ADD CONSTRAINT "FK_STATES_REF_DM_PROJ" FOREIGN KEY ("PROJ_ID")
- 
 
 1705 
	  REFERENCES "DM_PROJECTS" ("PROJ_ID") ENABLE;
- 
 
 1706 
/
4 
--------------------------------------------------------
 1707 
--------------------------------------------------------
5 
--  DDL for Function GET_DATE
 1708 
--  DDL for Function GET_DATE
6 
--------------------------------------------------------
 1709 
--------------------------------------------------------
7 
 
 1710 
 
8 
  CREATE OR REPLACE FUNCTION "GET_DATE" RETURN DATE IS
 1711 
  CREATE OR REPLACE FUNCTION "GET_DATE" RETURN DATE IS
Line 3126... Line 4829...
3126 
	END IF;
 4829 
	END IF;
3127
4830
3128
4831
3129 
END	Get_Next_Version;
 4832 
END	Get_Next_Version;
3130 
/*--------------------------------------------------------------------------------------------------*/
 4833 
/*--------------------------------------------------------------------------------------------------*/
3131 
PROCEDURE Release_To ( nBomId IN BOM_STATE.BOM_ID%TYPE,
 4834 
PROCEDURE Release_To ( nBomId    IN BOM_STATE.BOM_ID%TYPE,
3132 
					   nUserId IN BOM_STATE.USER_ID%TYPE,
 4835 
					             nUserId   IN BOM_STATE.USER_ID%TYPE,
3133 
					   nToState IN BOM_STATE.STATE_ID%TYPE DEFAULT NULL,
 4836 
					             nToState  IN BOM_STATE.STATE_ID%TYPE DEFAULT NULL,
3134 
					   sComments IN BOM_TRAIL.TRAIL_COMMENTS%TYPE DEFAULT NULL ) IS
 4837 
					             sComments IN BOM_TRAIL.TRAIL_COMMENTS%TYPE DEFAULT NULL ) IS
3135 
 
 4838 
 
3136 
rowCount NUMBER;
4839 
rowCount NUMBER;
3137 
IsOfficial BOMS.IS_READONLY%TYPE;
4840 
IsOfficial BOMS.IS_READONLY%TYPE;
3138 
StateId BOM_STATE.STATE_ID%TYPE;
 4841 
StateId BOM_STATE.STATE_ID%TYPE;
3139 
StateName STATES.STATE_NAME%TYPE;
 4842 
StateName STATES.STATE_NAME%TYPE;
Line 3163... Line 4866...
3163
4866
3164
4867
3165 
	-- Get State --
 4868 
	-- Get State --
3166 
	StateId := nToState;
 4869 
	StateId := nToState;
3167 
	IF StateId IS NULL THEN
 4870 
	IF StateId IS NULL THEN
- 
 
 4871 
    BEGIN
3168 
		-- If state_id is null it is considered as state_type_enum = 'BOM Creator'
 4872 
		-- If state_id is null it is considered as state_type_enum = 'BOM Creator'
3169 
		SELECT st.STATE_ID INTO StateId
 4873 
		SELECT st.STATE_ID INTO StateId
3170 
		  FROM BOMS bo,
 4874 
		  FROM BOMS bo,
3171 
		  	   BRANCHES br,
 4875 
		  	   BRANCHES br,
3172 
			   DM_PROJECTS proj,
 4876 
			   DM_PROJECTS proj,
3173 
			   STATES st
 4877 
			   STATES st
3174 
		 WHERE bo.BRANCH_ID = br.BRANCH_ID
 4878 
		 WHERE bo.BRANCH_ID = br.BRANCH_ID
3175 
		   AND br.PROJ_ID = proj.PROJ_ID
 4879 
		   AND br.PROJ_ID = proj.PROJ_ID
3176 
		   AND st.PROJ_ID = proj.PROJ_ID
 4880 
		   AND st.PROJ_ID = proj.PROJ_ID
3177 
		   AND bo.BOM_ID = nBomId
 4881 
		   AND bo.BOM_ID = nBomId
3178 
		   AND st.STATE_TYPE_ENUM = GET_SYSTEM_VALUE('enumSTATE_TYPE_CREATOR');
4882 
		   AND st.STATE_TYPE_ENUM = GET_SYSTEM_VALUE('enumSTATE_TYPE_CREATOR')
- 
 
 4883 
       AND rownum = 1
- 
 
 4884 
     ORDER BY st.STATE_ID;
- 
 
 4885 
     EXCEPTION  WHEN NO_DATA_FOUND THEN
- 
 
 4886 
       RAISE_APPLICATION_ERROR (-20000, 'Cannot find BOM Creator in project. Project is misconfigured! nBomId= '|| nBomId  );
- 
 
 4887 
   END;
- 
 
 4888
3179 
	END IF;
 4889 
	END IF;
3180
4890
3181
4891
3182 
	-- Add Bom to State --
 4892 
	-- Add Bom to State --
3183 
	INSERT INTO BOM_STATE (BOM_ID, STATE_ID, DATE_STAMP, IS_DISPLAYED, USER_ID )
 4893 
	INSERT INTO BOM_STATE (BOM_ID, STATE_ID, DATE_STAMP, IS_DISPLAYED, USER_ID )
Line 8466... Line 10176...
8466 
    Version: 1.0.0
 10176 
    Version: 1.0.0
8467 
   --------------------------------------------------------------------------- */
 10177 
   --------------------------------------------------------------------------- */
8468
10178
8469
10179
8470 
/*--------------------------------------------------------------------------------------------------*/
 10180 
/*--------------------------------------------------------------------------------------------------*/
8471 
PROCEDURE Add_State ( sStateName IN STATES.STATE_NAME%TYPE,
 10181 
PROCEDURE Add_State ( sStateName     IN STATES.STATE_NAME%TYPE,
8472 
		  			  nStateTypeEnum IN STATES.STATE_TYPE_ENUM%TYPE,
 10182 
		  			          nStateTypeEnum IN STATES.STATE_TYPE_ENUM%TYPE,
8473 
		  			  nProjId IN STATES.PROJ_ID%TYPE ) IS
 10183 
		  			          nProjId        IN STATES.PROJ_ID%TYPE ) IS
8474 
 
 10184 
 
8475 
StateId NUMBER;
 10185 
StateId      NUMBER;
8476 
NextStateSeq NUMBER;
 10186 
NextStateSeq NUMBER;
8477 
 
 - 
 
8478
10187
8479 
BEGIN
 10188 
BEGIN
8480 
	/*--------------- Business Rules Here -------------------*/
 10189 
	/*--------------- Business Rules Here -------------------*/
8481 
	/*-------------------------------------------------------*/
 10190 
	/*-------------------------------------------------------*/
8482
10191
8483 
	-- Get state_id --
 10192 
	-- Get state_id --
8484 
	SELECT SEQ_STATE_ID.NEXTVAL INTO StateId FROM DUAL;
 10193 
	SELECT SEQ_STATE_ID.NEXTVAL INTO StateId FROM DUAL;
8485
10194
- 
 
 10195
8486 
	-- Get Next Release Sequence
 10196 
	-- Get Next Release Sequence
8487 
	SELECT MAX( st.STATE_SEQ ) INTO NextStateSeq
 10197 
	SELECT MAX( st.STATE_SEQ ) INTO NextStateSeq
8488 
	  FROM STATES st
 10198 
	  FROM STATES st
8489 
	 WHERE st.PROJ_ID = nProjId;
 10199 
	 WHERE st.PROJ_ID = nProjId;
8490
10200
Line 8505... Line 10215...
8505 
	THEN
10215 
	THEN
8506 
		RAISE_APPLICATION_ERROR (-20000, 'State Name "'|| sStateName ||'" is Already Used.');
 10216 
		RAISE_APPLICATION_ERROR (-20000, 'State Name "'|| sStateName ||'" is Already Used.');
8507
10217
8508 
END	Add_State;
 10218 
END	Add_State;
8509 
/*--------------------------------------------------------------------------------------------------*/
 10219 
/*--------------------------------------------------------------------------------------------------*/
8510 
PROCEDURE Update_State ( nStateId IN STATES.STATE_ID%TYPE,
 10220 
PROCEDURE Update_State ( nStateId       IN STATES.STATE_ID%TYPE,
8511 
		  			   	 sStateName IN STATES.STATE_NAME%TYPE,
 10221 
		  			   	         sStateName     IN STATES.STATE_NAME%TYPE,
8512 
						 nStateSeq IN STATES.STATE_SEQ%TYPE,
 10222 
						             nStateSeq      IN STATES.STATE_SEQ%TYPE,
8513 
						 nStateTypeEnum IN STATES.STATE_TYPE_ENUM%TYPE ) IS
 10223 
						             nStateTypeEnum IN STATES.STATE_TYPE_ENUM%TYPE ) IS
8514 
 
 10224 
 
8515 
currSeqNum NUMBER;
 10225 
currSeqNum NUMBER;
8516 
FromSeqNum NUMBER;
 10226 
FromSeqNum NUMBER;
8517 
ProjId NUMBER;
 10227 
ProjId NUMBER;
8518
10228
Line 8520... Line 10230...
8520 
	/*--------------- Business Rules Here -------------------*/
 10230 
	/*--------------- Business Rules Here -------------------*/
8521 
	/*-------------------------------------------------------*/
 10231 
	/*-------------------------------------------------------*/
8522 
	-- Get State proj_id --
 10232 
	-- Get State proj_id --
8523 
	SELECT st.PROJ_ID INTO ProjId  FROM STATES st WHERE st.STATE_ID = nStateId;
 10233 
	SELECT st.PROJ_ID INTO ProjId  FROM STATES st WHERE st.STATE_ID = nStateId;
8524
10234
8525
10235
8526 
	-- Get Current seq_num
 10236 
	-- Get Current seq_num
8527 
	SELECT st.STATE_SEQ INTO currSeqNum
 10237 
	SELECT st.STATE_SEQ INTO currSeqNum
8528 
	  FROM STATES st
 10238 
	  FROM STATES st
8529 
	 WHERE st.STATE_ID = nStateId;
 10239 
	 WHERE st.STATE_ID = nStateId;
8530
10240
Line 9562... Line 11272...
9562 
END WRITE_PRODUCTION_HISTORY;
 11272 
END WRITE_PRODUCTION_HISTORY;
9563 
 
 11273 
 
9564 
/
 11274 
/
9565 
 
 11275 
 
9566 
/
 11276 
/
- 
 
 11277 
--------------------------------------------------------
- 
 
 11278 
--  DDL for Synonymn APPLICATIONS
- 
 
 11279 
--------------------------------------------------------
- 
 
 11280 
 
- 
 
 11281 
  CREATE OR REPLACE SYNONYM "APPLICATIONS" FOR "APPLICATIONS";
- 
 
 11282 
/
- 
 
 11283 
--------------------------------------------------------
- 
 
 11284 
--  DDL for Synonymn APPLICATION_PAGES
- 
 
 11285 
--------------------------------------------------------
- 
 
 11286 
 
- 
 
 11287 
  CREATE OR REPLACE SYNONYM "APPLICATION_PAGES" FOR "APPLICATION_PAGES";
- 
 
 11288 
/
- 
 
 11289 
--------------------------------------------------------
- 
 
 11290 
--  DDL for Synonymn CONTROL_OBJECTS
- 
 
 11291 
--------------------------------------------------------
- 
 
 11292 
 
- 
 
 11293 
  CREATE OR REPLACE SYNONYM "CONTROL_OBJECTS" FOR "CONTROL_OBJECTS";
- 
 
 11294 
/
- 
 
 11295 
--------------------------------------------------------
- 
 
 11296 
--  DDL for Synonymn CQ_ISSUES
- 
 
 11297 
--------------------------------------------------------
- 
 
 11298 
 
- 
 
 11299 
  CREATE OR REPLACE SYNONYM "CQ_ISSUES" FOR "CQ_ISSUES";
- 
 
 11300 
/
- 
 
 11301 
--------------------------------------------------------
- 
 
 11302 
--  DDL for Synonymn DATA_PERMISSIONS
- 
 
 11303 
--------------------------------------------------------
- 
 
 11304 
 
- 
 
 11305 
  CREATE OR REPLACE SYNONYM "DATA_PERMISSIONS" FOR "DATA_PERMISSIONS";
- 
 
 11306 
/
- 
 
 11307 
--------------------------------------------------------
- 
 
 11308 
--  DDL for Synonymn DATA_TABLES
- 
 
 11309 
--------------------------------------------------------
- 
 
 11310 
 
- 
 
 11311 
  CREATE OR REPLACE SYNONYM "DATA_TABLES" FOR "DATA_TABLES";
- 
 
 11312 
/
- 
 
 11313 
--------------------------------------------------------
- 
 
 11314 
--  DDL for Synonymn JIRA_ISSUES
- 
 
 11315 
--------------------------------------------------------
- 
 
 11316 
 
- 
 
 11317 
  CREATE OR REPLACE SYNONYM "JIRA_ISSUES" FOR "JIRA_ISSUES";
- 
 
 11318 
/
- 
 
 11319 
--------------------------------------------------------
- 
 
 11320 
--  DDL for Synonymn PACKAGES
- 
 
 11321 
--------------------------------------------------------
- 
 
 11322 
 
- 
 
 11323 
  CREATE OR REPLACE SYNONYM "PACKAGES" FOR "PACKAGES";
- 
 
 11324 
/
- 
 
 11325 
--------------------------------------------------------
- 
 
 11326 
--  DDL for Synonymn PACKAGE_DEPENDENCIES
- 
 
 11327 
--------------------------------------------------------
- 
 
 11328 
 
- 
 
 11329 
  CREATE OR REPLACE SYNONYM "PACKAGE_DEPENDENCIES" FOR "PACKAGE_DEPENDENCIES";
- 
 
 11330 
/
- 
 
 11331 
--------------------------------------------------------
- 
 
 11332 
--  DDL for Synonymn PACKAGE_PATCHES
- 
 
 11333 
--------------------------------------------------------
- 
 
 11334 
 
- 
 
 11335 
  CREATE OR REPLACE SYNONYM "PACKAGE_PATCHES" FOR "PACKAGE_PATCHES";
- 
 
 11336 
/
- 
 
 11337 
--------------------------------------------------------
- 
 
 11338 
--  DDL for Synonymn PACKAGE_VERSIONS
- 
 
 11339 
--------------------------------------------------------
- 
 
 11340 
 
- 
 
 11341 
  CREATE OR REPLACE SYNONYM "PACKAGE_VERSIONS" FOR "PACKAGE_VERSIONS";
- 
 
 11342 
/
- 
 
 11343 
--------------------------------------------------------
- 
 
 11344 
--  DDL for Synonymn PAGE_CONTROL_OBJECTS
- 
 
 11345 
--------------------------------------------------------
- 
 
 11346 
 
- 
 
 11347 
  CREATE OR REPLACE SYNONYM "PAGE_CONTROL_OBJECTS" FOR "PAGE_CONTROL_OBJECTS";
- 
 
 11348 
/
- 
 
 11349 
--------------------------------------------------------
- 
 
 11350 
--  DDL for Synonymn PERMISSION_TYPES
- 
 
 11351 
--------------------------------------------------------
- 
 
 11352 
 
- 
 
 11353 
  CREATE OR REPLACE SYNONYM "PERMISSION_TYPES" FOR "PERMISSION_TYPES";
- 
 
 11354 
/
- 
 
 11355 
--------------------------------------------------------
- 
 
 11356 
--  DDL for Synonymn PK_AMUTILS
- 
 
 11357 
--------------------------------------------------------
- 
 
 11358 
 
- 
 
 11359 
  CREATE OR REPLACE SYNONYM "PK_AMUTILS" FOR "PK_AMUTILS";
- 
 
 11360 
/
- 
 
 11361 
--------------------------------------------------------
- 
 
 11362 
--  DDL for Synonymn PK_SECURITY
- 
 
 11363 
--------------------------------------------------------
- 
 
 11364 
 
- 
 
 11365 
  CREATE OR REPLACE SYNONYM "PK_SECURITY" FOR "PK_SECURITY";
- 
 
 11366 
/
- 
 
 11367 
--------------------------------------------------------
- 
 
 11368 
--  DDL for Synonymn PLATFORMS
- 
 
 11369 
--------------------------------------------------------
- 
 
 11370 
 
- 
 
 11371 
  CREATE OR REPLACE SYNONYM "PLATFORMS" FOR "PLATFORMS";
- 
 
 11372 
/
- 
 
 11373 
--------------------------------------------------------
- 
 
 11374 
--  DDL for Synonymn PROCESSES
- 
 
 11375 
--------------------------------------------------------
- 
 
 11376 
 
- 
 
 11377 
  CREATE OR REPLACE SYNONYM "PROCESSES" FOR "PROCESSES";
- 
 
 11378 
/
- 
 
 11379 
--------------------------------------------------------
- 
 
 11380 
--  DDL for Synonymn PRODUCT_COMPONENTS
- 
 
 11381 
--------------------------------------------------------
- 
 
 11382 
 
- 
 
 11383 
  CREATE OR REPLACE SYNONYM "PRODUCT_COMPONENTS" FOR "PRODUCT_COMPONENTS";
- 
 
 11384 
/
- 
 
 11385 
--------------------------------------------------------
- 
 
 11386 
--  DDL for Synonymn PROJECTS
- 
 
 11387 
--------------------------------------------------------
- 
 
 11388 
 
- 
 
 11389 
  CREATE OR REPLACE SYNONYM "PROJECTS" FOR "PROJECTS";
- 
 
 11390 
/
- 
 
 11391 
--------------------------------------------------------
- 
 
 11392 
--  DDL for Synonymn PROJECT_EXTENTIONS
- 
 
 11393 
--------------------------------------------------------
- 
 
 11394 
 
- 
 
 11395 
  CREATE OR REPLACE SYNONYM "PROJECT_EXTENTIONS" FOR "PROJECT_EXTENTIONS";
- 
 
 11396 
/
- 
 
 11397 
--------------------------------------------------------
- 
 
 11398 
--  DDL for Synonymn RELEASE_CONTENT
- 
 
 11399 
--------------------------------------------------------
- 
 
 11400 
 
- 
 
 11401 
  CREATE OR REPLACE SYNONYM "RELEASE_CONTENT" FOR "RELEASE_CONTENT";
- 
 
 11402 
/
- 
 
 11403 
--------------------------------------------------------
- 
 
 11404 
--  DDL for Synonymn RELEASE_TAGS
- 
 
 11405 
--------------------------------------------------------
- 
 
 11406 
 
- 
 
 11407 
  CREATE OR REPLACE SYNONYM "RELEASE_TAGS" FOR "RELEASE_TAGS";
- 
 
 11408 
/
- 
 
 11409 
--------------------------------------------------------
- 
 
 11410 
--  DDL for Synonymn RM_USERS
- 
 
 11411 
--------------------------------------------------------
- 
 
 11412 
 
- 
 
 11413 
  CREATE OR REPLACE SYNONYM "RM_USERS" FOR "USERS";
- 
 
 11414 
/
- 
 
 11415 
--------------------------------------------------------
- 
 
 11416 
--  DDL for Synonymn ROLES
- 
 
 11417 
--------------------------------------------------------
- 
 
 11418 
 
- 
 
 11419 
  CREATE OR REPLACE SYNONYM "ROLES" FOR "ROLES";
- 
 
 11420 
/
- 
 
 11421 
--------------------------------------------------------
- 
 
 11422 
--  DDL for Synonymn ROLE_PRIVILEGES
- 
 
 11423 
--------------------------------------------------------
- 
 
 11424 
 
- 
 
 11425 
  CREATE OR REPLACE SYNONYM "ROLE_PRIVILEGES" FOR "ROLE_PRIVILEGES";
- 
 
 11426 
/
- 
 
 11427 
--------------------------------------------------------
- 
 
 11428 
--  DDL for Synonymn SEED_PACKAGE_NAMES_VERSIONS
- 
 
 11429 
--------------------------------------------------------
- 
 
 11430 
 
- 
 
 11431 
  CREATE OR REPLACE SYNONYM "SEED_PACKAGE_NAMES_VERSIONS" FOR "SEED_PACKAGE_NAMES_VERSIONS";
- 
 
 11432 
/
- 
 
 11433 
--------------------------------------------------------
- 
 
 11434 
--  DDL for Synonymn USERS
- 
 
 11435 
--------------------------------------------------------
- 
 
 11436 
 
- 
 
 11437 
  CREATE OR REPLACE SYNONYM "USERS" FOR "USERS";
- 
 
 11438 
/
- 
 
 11439 
--------------------------------------------------------
- 
 
 11440 
--  DDL for Synonymn USER_APPLICATIONS
- 
 
 11441 
--------------------------------------------------------
- 
 
 11442 
 
- 
 
 11443 
  CREATE OR REPLACE SYNONYM "USER_APPLICATIONS" FOR "USER_APPLICATIONS";
- 
 
 11444 
/
- 
 
 11445 
--------------------------------------------------------
- 
 
 11446 
--  DDL for Synonymn USER_ROLES
- 
 
 11447 
--------------------------------------------------------
- 
 
 11448 
 
- 
 
 11449 
  CREATE OR REPLACE SYNONYM "USER_ROLES" FOR "USER_ROLES";
- 
 
 11450 
/
- 
 
 11451 
--------------------------------------------------------
- 
 
 11452 
--  DDL for Synonymn VTREES
- 
 
 11453 
--------------------------------------------------------
- 
 
 11454 
 
- 
 
 11455 
  CREATE OR REPLACE SYNONYM "VTREES" FOR "VTREES";
- 
 
 11456 
/
- 
 
 11457 
--------------------------------------------------------
- 
 
 11458 
--  DDL for Synonymn VTREES_WORLD
- 
 
 11459 
--------------------------------------------------------
- 
 
 11460 
 
- 
 
 11461 
  CREATE OR REPLACE SYNONYM "VTREES_WORLD" FOR "VTREES_WORLD";
- 
 
 11462 
/