1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146
|
CREATE TABLE FAL_LOT
(
FAL_LOT_ID NUMBER(12) NOT NULL,
DIC_LOT_CODE2_ID VARCHAR2(10 BYTE),
C_LOT_STATUS VARCHAR2(10 BYTE) NOT NULL,
LOT_PLAN_END_DTE DATE,
LOT_PSHORT_DESCR VARCHAR2(50 BYTE),
LOT_REFCOMPL VARCHAR2(100 BYTE) NOT NULL
)
--SQL Statement which produced this data:
--
-- SELECT LOT.FAL_LOT_ID,
-- LOT.DIC_LOT_CODE2_ID as CODE
-- ,LOT.LOT_REFCOMPL
-- ,LOT.C_LOT_STATUS
-- ,LOT.LOT_PSHORT_DESCR
-- ,LOT.LOT_PLAN_END_DTE
-- from FAL_LOT LOT
-- where LOT.FAL_LOT_ID = 15673292
--
Insert into FAL_LOT
(FAL_LOT_ID,
CODE, LOT_REFCOMPL, C_LOT_STATUS, LOT_PSHORT_DESCR, LOT_PLAN_END_DTE)
Values
(15673292, NULL, 'OF-10-200670-01', '2', 'Clifton DD9000 Bleu',
TO_DATE('11/30/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
COMMIT;
CREATE TABLE FAL_TASK_LINK
(
FAL_SCHEDULE_STEP_ID NUMBER(12) NOT NULL,
FAL_LOT_ID NUMBER(12) NOT NULL,
TAL_AVALAIBLE_QTY NUMBER(15,4),
SCS_STEP_NUMBER NUMBER(9) NOT NULL,
FAL_TASK_ID NUMBER(12) NOT NULL,
TAL_BEGIN_REAL_DATE DATE
)
--SQL Statement which produced this data:
--
-- SELECT LIN.FAL_LOT_ID,
-- LIN.SCS_STEP_NUMBER as seq
-- ,LIN.TAL_AVALAIBLE_QTY
-- ,LIN.TAL_BEGIN_REAL_DATE Date_Début
-- from FAL_TASK_LINK LIN
-- where LIN.FAL_LOT_ID = 15673292
-- ORDER BY LIN.SCS_STEP_NUMBER asc
--
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 10, 0, TO_DATE('10/16/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 20, 0, TO_DATE('10/24/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 30, 473, TO_DATE('10/29/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 40, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 50, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 60, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 70, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 80, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 90, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 100, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 110, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 120, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 130, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 140, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 150, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 160, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 170, 0, NULL);
Insert into FAL_TASK_LINK
(FAL_LOT_ID,
SEQ, TAL_AVALAIBLE_QTY, DATE_DÉBUT)
Values
(15673292, 180, 0, NULL);
COMMIT; |
Partager