1 PACKAGE BODY ddr_setup_util AS
2 /* $Header: ddrstpub.pls 120.2.12010000.7 2010/03/15 22:01:55 gglover ship $ */
3
4 v_version CONSTANT VARCHAR2(30):= 'DDR seed verion 1.1';
5
6 PROCEDURE Raise_Error (p_error_text IN VARCHAR2)
7 IS
8 l_error_text VARCHAR2(240);
9 BEGIN
10 l_error_text := p_error_text;
11 Raise_Application_Error(-20001,l_error_text);
12 END Raise_Error;
13
14 PROCEDURE setup(p_mfg_org VARCHAR2) IS
15 v_org_exists NUMBER:=0;
16 BEGIN
17 setup_mfg_org(p_mfg_org);
18 setup_ws_metadata;
19 setup_lookup_type;
20 setup_lookup(p_mfg_org);
21 commit;
22 END setup;
23
24 PROCEDURE setup_mfg_org(p_mfg_org VARCHAR2) IS
25 v_org_exists NUMBER:=0;
26 BEGIN
27 SELECT COUNT(*)
28 INTO v_org_exists
29 FROM DDR_R_ORG
30 WHERE mfg_org_cd = p_mfg_org
31 AND org_cd = p_mfg_org;
32
33 IF v_org_exists = 0 THEN
34 INSERT INTO ddr_r_org
35 (mfg_org_cd, org_cd, org_typ, glbl_loc_id, glbl_loc_id_typ,
36 created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
37 VALUES
38 (p_mfg_org, p_mfg_org, 'MFG', -1, -1,
39 -1, SYSDATE, '-1', SYSDATE, '-1', v_version, SYSDATE, '-1', '-1');
40 END IF;
41 END setup_mfg_org;
42
43 PROCEDURE setup_lookup(p_mfg_org VARCHAR2) IS
44 BEGIN
45 --DELETE ddr_r_lkup_mst
46 --WHERE mfg_org_cd = p_mfg_org;
47
48 MERGE INTO ddr_r_lkup_mst lkup USING dual
49 ON (lkup.lkup_typ_cd = 'BSNS_UNIT_TYP' AND lkup.lkup_cd = 'CATALOGUE')
50 WHEN NOT MATCHED THEN INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
51 VALUES (p_mfg_org,'BSNS_UNIT_TYP','CATALOGUE','Catalogue','Catalogue',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
52
53 MERGE INTO ddr_r_lkup_mst lkup USING dual
54 ON (lkup.lkup_typ_cd = 'BSNS_UNIT_TYP' AND lkup.lkup_cd = 'DC')
55 WHEN NOT MATCHED THEN INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
56 VALUES (p_mfg_org,'BSNS_UNIT_TYP','DC','Distribution Centre','Distribution Centre',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
57
58 MERGE INTO ddr_r_lkup_mst lkup USING dual
59 ON (lkup.lkup_typ_cd = 'BSNS_UNIT_TYP' AND lkup.lkup_cd = 'RTLSTORE')
60 WHEN NOT MATCHED THEN INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
61 VALUES (p_mfg_org,'BSNS_UNIT_TYP','RTLSTORE','Retail Store','Retail Store',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
62
63 MERGE INTO ddr_r_lkup_mst lkup USING dual
64 ON (lkup.lkup_typ_cd = 'BSNS_UNIT_TYP' AND lkup.lkup_cd = 'WAREHOUSE')
65 WHEN NOT MATCHED THEN
66 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
67 VALUES (p_mfg_org,'BSNS_UNIT_TYP','WAREHOUSE','Warehouse','Warehouse',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
68
69 MERGE INTO ddr_r_lkup_mst lkup USING dual
70 ON (lkup.lkup_typ_cd = 'BSNS_UNIT_TYP' AND lkup.lkup_cd = 'WEBSTORE')
71 WHEN NOT MATCHED THEN
72 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
73 VALUES (p_mfg_org,'BSNS_UNIT_TYP','WEBSTORE','Web Store','Web Store',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
74
75
76 MERGE INTO ddr_r_lkup_mst lkup USING dual
77 ON (lkup.lkup_typ_cd = 'BSNS_UNIT_TYP' AND lkup.lkup_cd = 'MFG')
78 WHEN NOT MATCHED THEN
79 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
80 VALUES (p_mfg_org,'BSNS_UNIT_TYP','MFG','Manufacturer','Manufacturer',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
81
82
83 MERGE INTO ddr_r_lkup_mst lkup USING dual
84 ON (lkup.lkup_typ_cd = 'CHNL_TYP' AND lkup.lkup_cd = 'Direct')
85 WHEN NOT MATCHED THEN
86 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
87 VALUES (p_mfg_org,'CHNL_TYP','Direct','Direct','Direct',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
88
89 MERGE INTO ddr_r_lkup_mst lkup USING dual
90 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1001')
91 WHEN NOT MATCHED THEN
92 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
93 VALUES (p_mfg_org,'ERR','DSR-1001','NULL not allowed','This column value can not be NULL, please provide non NULL value',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
94
95 MERGE INTO ddr_r_lkup_mst lkup USING dual
96 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1002')
97 WHEN NOT MATCHED THEN
98 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
99 VALUES (p_mfg_org,'ERR','DSR-1002','Invalid Value','No matching value found in setup, please provide valid column value',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
100
101 MERGE INTO ddr_r_lkup_mst lkup USING dual
102 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1003')
103 WHEN NOT MATCHED THEN
104 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
105 VALUES (p_mfg_org,'ERR','DSR-1003','Zero Value','This column can not have zero values, please provide non zero value',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
106
107 MERGE INTO ddr_r_lkup_mst lkup USING dual
108 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1004')
109 WHEN NOT MATCHED THEN
110 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
111 VALUES (p_mfg_org,'ERR','DSR-1004','Invalid item association','The item is not authorized to be sold from this Business Unit',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
112
113 MERGE INTO ddr_r_lkup_mst lkup USING dual
114 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1005')
115 WHEN NOT MATCHED THEN
116 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
117 VALUES (p_mfg_org,'ERR','DSR-1005','Invalid Organization Type','Invalid Organization Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
118
119 MERGE INTO ddr_r_lkup_mst lkup USING dual
120 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1006')
121 WHEN NOT MATCHED THEN
122 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
123 VALUES (p_mfg_org,'ERR','DSR-1006','Invalid Combination','Invalid Combination',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
124
125 MERGE INTO ddr_r_lkup_mst lkup USING dual
126 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1007')
127 WHEN NOT MATCHED THEN
128 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
129 VALUES (p_mfg_org,'ERR','DSR-1007','Inactive Business Unit','The Business Unit is not operational',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
130
131 MERGE INTO ddr_r_lkup_mst lkup USING dual
132 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1008')
133 WHEN NOT MATCHED THEN
134 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
135 VALUES (p_mfg_org,'ERR','DSR-1008','Time Alloc % Not Found','No record found for Time allocation in setup ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
136
137 MERGE INTO ddr_r_lkup_mst lkup USING dual
138 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1009')
139 WHEN NOT MATCHED THEN
140 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
141 VALUES (p_mfg_org,'ERR','DSR-1009','Org Alloc % Not Found','No record found for Organization allocation in setup',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
142
143 MERGE INTO ddr_r_lkup_mst lkup USING dual
144 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1010')
145 WHEN NOT MATCHED THEN
146 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
147 VALUES (p_mfg_org,'ERR','DSR-1010','No UOM conversion Found','No matching value found in the setup conversion table',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
148
149 MERGE INTO ddr_r_lkup_mst lkup USING dual
150 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1011')
151 WHEN NOT MATCHED THEN
152 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
153 VALUES (p_mfg_org,'ERR','DSR-1011','No Exchange Rate found ','No matching value found in the setup exchange rate table',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
154
155 MERGE INTO ddr_r_lkup_mst lkup USING dual
156 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1012')
157 WHEN NOT MATCHED THEN
158 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
159 VALUES (p_mfg_org,'ERR','DSR-1012','Inactive Item','The Item has expired',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
160
161 MERGE INTO ddr_r_lkup_mst lkup USING dual
162 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1013')
163 WHEN NOT MATCHED THEN
164 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
165 VALUES (p_mfg_org,'ERR','DSR-1013','Clustrtyp and BU combination exists','Cluster type and BU combination already exists',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
166
167 MERGE INTO ddr_r_lkup_mst lkup USING dual
168 ON (lkup.lkup_typ_cd = 'ERR' AND lkup.lkup_cd = 'DSR-1014')
169 WHEN NOT MATCHED THEN
170 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
171 VALUES (p_mfg_org,'ERR','DSR-1014','ItmClustrTyp and SKU combination exists','Item Cluster type and SKU Item combination already exists',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
172
173
174 MERGE INTO ddr_r_lkup_mst lkup USING dual
175 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = '% RETURNS')
176 WHEN NOT MATCHED THEN
177 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
178 VALUES (p_mfg_org,'MEASURE','% RETURNS','% RETURNS','% Returns',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
179
180 MERGE INTO ddr_r_lkup_mst lkup USING dual
181 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'CATEGORY MONETARY SALES')
182 WHEN NOT MATCHED THEN
183 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
184 VALUES (p_mfg_org,'MEASURE','CATEGORY MONETARY SALES','CATEGORY MONETARY SALES','CATEGORY MONETARY SALES',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
185
186 MERGE INTO ddr_r_lkup_mst lkup USING dual
187 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'DEDUCTION AMT')
188 WHEN NOT MATCHED THEN
189 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
190 VALUES (p_mfg_org,'MEASURE','DEDUCTION AMT','Deduction Amount','Deduction Amount',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
191
192 MERGE INTO ddr_r_lkup_mst lkup USING dual
193 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'DEDUCTION BALANCE')
194 WHEN NOT MATCHED THEN
195 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
196 VALUES (p_mfg_org,'MEASURE','DEDUCTION BALANCE','Deduction Balance','Deduction Balance',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
197
198
199 MERGE INTO ddr_r_lkup_mst lkup USING dual
200 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'DOLLAR SALE')
201 WHEN NOT MATCHED THEN
202 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
203 VALUES (p_mfg_org,'MEASURE','DOLLAR SALE','Dollar Sale','Dollar Sale',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
204
205 MERGE INTO ddr_r_lkup_mst lkup USING dual
206 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'GROSS MARGIN')
207 WHEN NOT MATCHED THEN
208 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
212 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'IN STOCK %')
209 VALUES (p_mfg_org,'MEASURE','GROSS MARGIN','Gross Margin','Gross Margin',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
210
211 MERGE INTO ddr_r_lkup_mst lkup USING dual
213 WHEN NOT MATCHED THEN
214 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
215 VALUES (p_mfg_org,'MEASURE','IN STOCK %','IN STOCK %','In Stock % ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
216
217 MERGE INTO ddr_r_lkup_mst lkup USING dual
218 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'INVENTORY COVER MAX')
219 WHEN NOT MATCHED THEN
220 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
221 VALUES (p_mfg_org,'MEASURE','INVENTORY COVER MAX','INVENTORY COVER MAX','Inventory Cover max ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
222
223 MERGE INTO ddr_r_lkup_mst lkup USING dual
224 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'INVENTORY COVER MIN')
225 WHEN NOT MATCHED THEN
226 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
227 VALUES (p_mfg_org,'MEASURE','INVENTORY COVER MIN','INVENTORY COVER MIN','Inventory Cover min ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
228
229 MERGE INTO ddr_r_lkup_mst lkup USING dual
230 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'INVENTORY TURNS')
231 WHEN NOT MATCHED THEN
232 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
233 VALUES (p_mfg_org,'MEASURE','INVENTORY TURNS','Inventory Turns','Inventory Turns',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
234
235 MERGE INTO ddr_r_lkup_mst lkup USING dual
236 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'INVOICE ACCURACY')
237 WHEN NOT MATCHED THEN
238 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
239 VALUES (p_mfg_org,'MEASURE','INVOICE ACCURACY','Invoice Accuracy','Invoice Accuracy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
240
241 MERGE INTO ddr_r_lkup_mst lkup USING dual
242 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'ITEM DATA ACCURACY')
243 WHEN NOT MATCHED THEN
244 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
245 VALUES (p_mfg_org,'MEASURE','ITEM DATA ACCURACY','Item Data Accuracy','Item Data Accuracy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
246
247 MERGE INTO ddr_r_lkup_mst lkup USING dual
248 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'ITEM DATA SYNCHRONIZATION')
249 WHEN NOT MATCHED THEN
250 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
251 VALUES (p_mfg_org,'MEASURE','ITEM DATA SYNCHRONIZATION','Item Data Synchronization','Item Data Synchronization',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
252
253
254 MERGE INTO ddr_r_lkup_mst lkup USING dual
255 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'LATE PAYMENT')
256 WHEN NOT MATCHED THEN
257 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
258 VALUES (p_mfg_org,'MEASURE','LATE PAYMENT','Late Payment','Late Payment',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
259
260 MERGE INTO ddr_r_lkup_mst lkup USING dual
261 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'MONETARY SALES')
262 WHEN NOT MATCHED THEN
263 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
264 VALUES (p_mfg_org,'MEASURE','MONETARY SALES','MONETARY SALES','MONETARY SALES',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
265
266 MERGE INTO ddr_r_lkup_mst lkup USING dual
267 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'NO OF DEDUCTIONS')
268 WHEN NOT MATCHED THEN
269 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
270 VALUES (p_mfg_org,'MEASURE','NO OF DEDUCTIONS','No. of Deductions','No. of Deductions',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
271
272 MERGE INTO ddr_r_lkup_mst lkup USING dual
273 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'ON TIME DELIVERY DATE')
274 WHEN NOT MATCHED THEN
275 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
276 VALUES (p_mfg_org,'MEASURE','ON TIME DELIVERY DATE','On Time Delivery - Date','On Time Delivery - Date',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
277
278 MERGE INTO ddr_r_lkup_mst lkup USING dual
282 VALUES (p_mfg_org,'MEASURE','ON TIME DELIVERY TIME','On Time Delivery - Time','On Time Delivery - Time',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
279 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'ON TIME DELIVERY TIME')
280 WHEN NOT MATCHED THEN
281 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
283
284 MERGE INTO ddr_r_lkup_mst lkup USING dual
285 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'ON-HAND INVENTORY')
286 WHEN NOT MATCHED THEN
287 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
288 VALUES (p_mfg_org,'MEASURE','ON-HAND INVENTORY','ON-HAND INVENTORY','On-Hand Inventory ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
289
290 MERGE INTO ddr_r_lkup_mst lkup USING dual
291 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'ORDER CHANGE %')
292 WHEN NOT MATCHED THEN
293 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
294 VALUES (p_mfg_org,'MEASURE','ORDER CHANGE %','Order Change %','Order Change %',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
295
296 MERGE INTO ddr_r_lkup_mst lkup USING dual
297 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'ORDER CYCLE TIME')
298 WHEN NOT MATCHED THEN
299 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
300 VALUES (p_mfg_org,'MEASURE','ORDER CYCLE TIME','Order Cycle Time','Order Cycle Time',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
301
302 MERGE INTO ddr_r_lkup_mst lkup USING dual
303 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'PAYEMENT DAYS')
304 WHEN NOT MATCHED THEN
305 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
306 VALUES (p_mfg_org,'MEASURE','PAYEMENT DAYS','Payment Days','Payment Days',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
307
308 MERGE INTO ddr_r_lkup_mst lkup USING dual
309 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'PERFECT ORDER %')
310 WHEN NOT MATCHED THEN
311 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
312 VALUES (p_mfg_org,'MEASURE','PERFECT ORDER %','Perfect Order %','Perfect Order %',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
313
314 MERGE INTO ddr_r_lkup_mst lkup USING dual
315 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'RETAIL GROSS MARGIN (%)')
316 WHEN NOT MATCHED THEN
317 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
318 VALUES (p_mfg_org,'MEASURE','RETAIL GROSS MARGIN (%)','RETAIL GROSS MARGIN (%)','Retail Gross Margin (%)',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
319
320 MERGE INTO ddr_r_lkup_mst lkup USING dual
321 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'SALES FORECAST ACCURACY (%)')
322 WHEN NOT MATCHED THEN
323 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
324 VALUES (p_mfg_org,'MEASURE','SALES FORECAST ACCURACY (%)','SALES FORECAST ACCURACY (%)','Sales Forecast Accuracy (%)',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
325
326 MERGE INTO ddr_r_lkup_mst lkup USING dual
327 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'SERVICE LEVEL')
328 WHEN NOT MATCHED THEN
329 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
330 VALUES (p_mfg_org,'MEASURE','SERVICE LEVEL','SERVICE LEVEL','Service Level ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
331
332 MERGE INTO ddr_r_lkup_mst lkup USING dual
333 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'SHARE OF MARKET')
334 WHEN NOT MATCHED THEN
335 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
336 VALUES (p_mfg_org,'MEASURE','SHARE OF MARKET','Share of Market','Share of Market',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
337
338 MERGE INTO ddr_r_lkup_mst lkup USING dual
339 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'SHOPPER PENETRATION')
340 WHEN NOT MATCHED THEN
341 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
342 VALUES (p_mfg_org,'MEASURE','SHOPPER PENETRATION','Shopper Penetration','Shopper Penetration',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
343
344 MERGE INTO ddr_r_lkup_mst lkup USING dual
345 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'UNIT SALE')
346 WHEN NOT MATCHED THEN
350 MERGE INTO ddr_r_lkup_mst lkup USING dual
347 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
348 VALUES (p_mfg_org,'MEASURE','UNIT SALE','Unit Sale','Unit Sale',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
349
351 ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'UNSALEABLES')
352 WHEN NOT MATCHED THEN
353 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
354 VALUES (p_mfg_org,'MEASURE','UNSALEABLES','Unsaleables','Unsaleables',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
355
356 MERGE INTO ddr_r_lkup_mst lkup USING dual
357 ON (lkup.lkup_typ_cd = 'MEASURE_TYP' AND lkup.lkup_cd = 'EXTERNAL')
358 WHEN NOT MATCHED THEN
359 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
360 VALUES (p_mfg_org,'MEASURE_TYP','EXTERNAL','External Measure','External Measure',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
361
362 MERGE INTO ddr_r_lkup_mst lkup USING dual
363 ON (lkup.lkup_typ_cd = 'MEASURE_TYP' AND lkup.lkup_cd = 'GOAL')
364 WHEN NOT MATCHED THEN
365 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
366 VALUES (p_mfg_org,'MEASURE_TYP','GOAL','Goal','Goal',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
367
368 MERGE INTO ddr_r_lkup_mst lkup USING dual
369 ON (lkup.lkup_typ_cd = 'MEASURE_TYP' AND lkup.lkup_cd = 'THRESHOLD')
370 WHEN NOT MATCHED THEN
371 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
372 VALUES (p_mfg_org,'MEASURE_TYP','THRESHOLD','Threshold','Threshold',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
373
374 MERGE INTO ddr_r_lkup_mst lkup USING dual
375 ON (lkup.lkup_typ_cd = 'MFG_ITEM_LVL' AND lkup.lkup_cd = 'CLASS')
376 WHEN NOT MATCHED THEN
377 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
378 VALUES (p_mfg_org,'MFG_ITEM_LVL','CLASS','Item Class / Category','Item Class / Category',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
379
380 MERGE INTO ddr_r_lkup_mst lkup USING dual
381 ON (lkup.lkup_typ_cd = 'MFG_ITEM_LVL' AND lkup.lkup_cd = 'COMPANY')
382 WHEN NOT MATCHED THEN
383 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
384 VALUES (p_mfg_org,'MFG_ITEM_LVL','COMPANY','Item Company','Item Company',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
385
386 MERGE INTO ddr_r_lkup_mst lkup USING dual
387 ON (lkup.lkup_typ_cd = 'MFG_ITEM_LVL' AND lkup.lkup_cd = 'DIVISION')
388 WHEN NOT MATCHED THEN
389 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
390 VALUES (p_mfg_org,'MFG_ITEM_LVL','DIVISION','Item Division','Item Division',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
391
392 MERGE INTO ddr_r_lkup_mst lkup USING dual
393 ON (lkup.lkup_typ_cd = 'MFG_ITEM_LVL' AND lkup.lkup_cd = 'GROUP')
394 WHEN NOT MATCHED THEN
395 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
396 VALUES (p_mfg_org,'MFG_ITEM_LVL','GROUP','Item Group','Item Group',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
397
398 MERGE INTO ddr_r_lkup_mst lkup USING dual
399 ON (lkup.lkup_typ_cd = 'MFG_ITEM_LVL' AND lkup.lkup_cd = 'ITEM')
400 WHEN NOT MATCHED THEN
401 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
402 VALUES (p_mfg_org,'MFG_ITEM_LVL','ITEM','Item','Item',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
403
404 MERGE INTO ddr_r_lkup_mst lkup USING dual
405 ON (lkup.lkup_typ_cd = 'MFG_ITEM_LVL' AND lkup.lkup_cd = 'NA')
406 WHEN NOT MATCHED THEN
407 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
408 VALUES (p_mfg_org,'MFG_ITEM_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
409
410 MERGE INTO ddr_r_lkup_mst lkup USING dual
411 ON (lkup.lkup_typ_cd = 'MFG_ITEM_LVL' AND lkup.lkup_cd = 'SKU')
412 WHEN NOT MATCHED THEN
413 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
414 VALUES (p_mfg_org,'MFG_ITEM_LVL','SKU','SKU','SKU',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
415
416 MERGE INTO ddr_r_lkup_mst lkup USING dual
417 ON (lkup.lkup_typ_cd = 'MFG_ITEM_LVL' AND lkup.lkup_cd = 'SUBCLASS')
418 WHEN NOT MATCHED THEN
422 MERGE INTO ddr_r_lkup_mst lkup USING dual
419 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
420 VALUES (p_mfg_org,'MFG_ITEM_LVL','SUBCLASS','Item Sub-Class','Item Sub-Class',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
421
423 ON (lkup.lkup_typ_cd = 'ORG_LVL' AND lkup.lkup_cd = 'AREA')
424 WHEN NOT MATCHED THEN
425 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
426 VALUES (p_mfg_org,'ORG_LVL','AREA','Area','Area',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
427
428 MERGE INTO ddr_r_lkup_mst lkup USING dual
429 ON (lkup.lkup_typ_cd = 'ORG_LVL' AND lkup.lkup_cd = 'BU')
430 WHEN NOT MATCHED THEN
431 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
432 VALUES (p_mfg_org,'ORG_LVL','BU','Business Unit','Business Unit',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
433
434 MERGE INTO ddr_r_lkup_mst lkup USING dual
435 ON (lkup.lkup_typ_cd = 'ORG_LVL' AND lkup.lkup_cd = 'CHAIN')
436 WHEN NOT MATCHED THEN
437 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
438 VALUES (p_mfg_org,'ORG_LVL','CHAIN','Chain','Chain',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
439
440 MERGE INTO ddr_r_lkup_mst lkup USING dual
441 ON (lkup.lkup_typ_cd = 'ORG_LVL' AND lkup.lkup_cd = 'DISTRICT')
442 WHEN NOT MATCHED THEN
443 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
444 VALUES (p_mfg_org,'ORG_LVL','DISTRICT','District','District',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
445
446 MERGE INTO ddr_r_lkup_mst lkup USING dual
447 ON (lkup.lkup_typ_cd = 'ORG_LVL' AND lkup.lkup_cd = 'NA')
448 WHEN NOT MATCHED THEN
449 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
450 VALUES (p_mfg_org,'ORG_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
451
452 MERGE INTO ddr_r_lkup_mst lkup USING dual
453 ON (lkup.lkup_typ_cd = 'ORG_LVL' AND lkup.lkup_cd = 'ORGANIZATION')
454 WHEN NOT MATCHED THEN
455 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
456 VALUES (p_mfg_org,'ORG_LVL','ORGANIZATION','Organization','Organization',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
457
458 MERGE INTO ddr_r_lkup_mst lkup USING dual
459 ON (lkup.lkup_typ_cd = 'ORG_LVL' AND lkup.lkup_cd = 'REGION')
460 WHEN NOT MATCHED THEN
461 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
462 VALUES (p_mfg_org,'ORG_LVL','REGION','Region','Region',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
463
464 MERGE INTO ddr_r_lkup_mst lkup USING dual
465 ON (lkup.lkup_typ_cd = 'ORG_TYP' AND lkup.lkup_cd = 'CMP')
466 WHEN NOT MATCHED THEN
467 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
468 VALUES (p_mfg_org,'ORG_TYP','CMP','Competitor','Competitor',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
469
470 MERGE INTO ddr_r_lkup_mst lkup USING dual
471 ON (lkup.lkup_typ_cd = 'ORG_TYP' AND lkup.lkup_cd = 'MFG')
472 WHEN NOT MATCHED THEN
473 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
474 VALUES (p_mfg_org,'ORG_TYP','MFG','Manufacturer','Manufacturer',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
475
476 MERGE INTO ddr_r_lkup_mst lkup USING dual
477 ON (lkup.lkup_typ_cd = 'ORG_TYP' AND lkup.lkup_cd = 'RTL')
478 WHEN NOT MATCHED THEN
479 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
480 VALUES (p_mfg_org,'ORG_TYP','RTL','Retailer','Retailer',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
481
482
483 MERGE INTO ddr_r_lkup_mst lkup USING dual
484 ON (lkup.lkup_typ_cd = 'ORG_TYP' AND lkup.lkup_cd = 'DST')
485 WHEN NOT MATCHED THEN
486 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
487 VALUES (p_mfg_org,'ORG_TYP','DST','Distributor','Distributor',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
488
489
490 MERGE INTO ddr_r_lkup_mst lkup USING dual
491 ON (lkup.lkup_typ_cd = 'RTL_ITEM_LVL' AND lkup.lkup_cd = 'CLASS')
492 WHEN NOT MATCHED THEN
493 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
497 ON (lkup.lkup_typ_cd = 'RTL_ITEM_LVL' AND lkup.lkup_cd = 'COMPANY')
494 VALUES (p_mfg_org,'RTL_ITEM_LVL','CLASS','Item Class / Category','Item Class / Category',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
495
496 MERGE INTO ddr_r_lkup_mst lkup USING dual
498 WHEN NOT MATCHED THEN
499 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
500 VALUES (p_mfg_org,'RTL_ITEM_LVL','COMPANY','Item Company','Item Company',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
501
502 MERGE INTO ddr_r_lkup_mst lkup USING dual
503 ON (lkup.lkup_typ_cd = 'RTL_ITEM_LVL' AND lkup.lkup_cd = 'DEPARTMENT')
504 WHEN NOT MATCHED THEN
505 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
506 VALUES (p_mfg_org,'RTL_ITEM_LVL','DEPARTMENT','Item Department','Item Department',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
507
508 MERGE INTO ddr_r_lkup_mst lkup USING dual
509 ON (lkup.lkup_typ_cd = 'RTL_ITEM_LVL' AND lkup.lkup_cd = 'DIVISION')
510 WHEN NOT MATCHED THEN
511 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
512 VALUES (p_mfg_org,'RTL_ITEM_LVL','DIVISION','Item Division','Item Division',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
513
514 MERGE INTO ddr_r_lkup_mst lkup USING dual
515 ON (lkup.lkup_typ_cd = 'RTL_ITEM_LVL' AND lkup.lkup_cd = 'GROUP')
516 WHEN NOT MATCHED THEN
517 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
518 VALUES (p_mfg_org,'RTL_ITEM_LVL','GROUP','Item Group','Item Group',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
519
520
521 MERGE INTO ddr_r_lkup_mst lkup USING dual
522 ON (lkup.lkup_typ_cd = 'RTL_ITEM_LVL' AND lkup.lkup_cd = 'ITEM')
523 WHEN NOT MATCHED THEN
524 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
525 VALUES (p_mfg_org,'RTL_ITEM_LVL','ITEM','Item','Item',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
526
527 MERGE INTO ddr_r_lkup_mst lkup USING dual
528 ON (lkup.lkup_typ_cd = 'RTL_ITEM_LVL' AND lkup.lkup_cd = 'NA')
529 WHEN NOT MATCHED THEN
530 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
531 VALUES (p_mfg_org,'RTL_ITEM_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
532
533 MERGE INTO ddr_r_lkup_mst lkup USING dual
534 ON (lkup.lkup_typ_cd = 'RTL_ITEM_LVL' AND lkup.lkup_cd = 'SKU')
535 WHEN NOT MATCHED THEN
536 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
537 VALUES (p_mfg_org,'RTL_ITEM_LVL','SKU','SKU','SKU',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
538
539 MERGE INTO ddr_r_lkup_mst lkup USING dual
540 ON (lkup.lkup_typ_cd = 'RTL_ITEM_LVL' AND lkup.lkup_cd = 'SUBCLASS')
541 WHEN NOT MATCHED THEN
542 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
543 VALUES (p_mfg_org,'RTL_ITEM_LVL','SUBCLASS','Item Sub-Class','Item Sub-Class',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
544
545 MERGE INTO ddr_r_lkup_mst lkup USING dual
546 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'DISCOVERY_MODE')
547 WHEN NOT MATCHED THEN
548 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
549 VALUES (p_mfg_org,'SYS_PARAM','DISCOVERY_MODE','N','Discovery mode for POS Data: Possible values are N for Strict Mode and Y for Item Discovery Mode',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
550
551 MERGE INTO ddr_r_lkup_mst lkup USING dual
552 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'MAX_OUTPUT_RECORDS')
553 WHEN NOT MATCHED THEN
554 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
555 VALUES (p_mfg_org,'SYS_PARAM','MAX_OUTPUT_RECORDS','20000000','Maximum records that can be returned to the calling application through web services',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
556
557 MERGE INTO ddr_r_lkup_mst lkup USING dual
558 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'MAX_REC_PER_FILE')
559 WHEN NOT MATCHED THEN
560 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
561 VALUES (p_mfg_org,'SYS_PARAM','MAX_REC_PER_FILE','200000','Maximum number of records per output file created by web service',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
562
563 MERGE INTO ddr_r_lkup_mst lkup USING dual
564 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'OUTPUT_DIR_PATH')
565 WHEN NOT MATCHED THEN
569 MERGE INTO ddr_r_lkup_mst lkup USING dual
566 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
567 VALUES (p_mfg_org,'SYS_PARAM','OUTPUT_DIR_PATH',NULL,'Directory for web service output files',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
568
570 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'PERFORM_DUP_CHECK')
571 WHEN NOT MATCHED THEN
572 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
573 VALUES (p_mfg_org,'SYS_PARAM','PERFORM_DUP_CHECK','N','Duplicate record check for Fact data: Possible values are Y to perform check for duplicate records and N to skip check for duplicate records',v_version
574 ,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
575
576 MERGE INTO ddr_r_lkup_mst lkup USING dual
577 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'RUN_TYPE_FACT')
578 WHEN NOT MATCHED THEN
579 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
580 VALUES (p_mfg_org,'SYS_PARAM','RUN_TYPE_FACT','P','Data Load Mode for Fact data: Possible values are P for Partial data load, S for Simulation and A for All or None data load',v_version,SYSDATE,'-1','-1','-1'
581 ,SYSDATE,'-1',SYSDATE,'-1');
582
583 MERGE INTO ddr_r_lkup_mst lkup USING dual
584 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'RUN_TYP_REF')
585 WHEN NOT MATCHED THEN
586 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
587 VALUES (p_mfg_org,'SYS_PARAM','RUN_TYP_REF','P','Data Load Mode for Reference data: Possible values are P for Partial Load and S for Simulation Load',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
588
589 MERGE INTO ddr_r_lkup_mst lkup USING dual
590 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'STAGE_TO_TARGET_VALIDATION')
591 WHEN NOT MATCHED THEN
592 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
593 VALUES (p_mfg_org,'SYS_PARAM','STAGE_TO_TARGET_VALIDATION','N','Dangling key check for data in staging tables: Possible values are Y to perform dangling key validation, N to skip dangling key validation',v_version
594 ,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
595
596
597 MERGE INTO ddr_r_lkup_mst lkup USING dual
598 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'DDR_WS_FILE_PATH')
599 WHEN NOT MATCHED THEN
600 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
601 VALUES (p_mfg_org,'SYS_PARAM','DDR_WS_FILE_PATH',NULL,'Complete directory path for output files location',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
602
603 MERGE INTO ddr_r_lkup_mst lkup USING dual
604 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'DFLT_GLBL_LOC_ID_TYP')
605 WHEN NOT MATCHED THEN
606 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
607 VALUES (p_mfg_org,'SYS_PARAM','DFLT_GLBL_LOC_ID_TYP',NULL,'Default Global Location ID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
608
609 MERGE INTO ddr_r_lkup_mst lkup USING dual
610 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'DFLT_ADDR_TYP_CD')
611 WHEN NOT MATCHED THEN
612 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
613 VALUES (p_mfg_org,'SYS_PARAM','DFLT_ADDR_TYP_CD',NULL,'Default Address Type Code',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
614
615 MERGE INTO ddr_r_lkup_mst lkup USING dual
616 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'DFLT_PRMRY_CRNCY_CD')
617 WHEN NOT MATCHED THEN
618 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
619 VALUES (p_mfg_org,'SYS_PARAM','DFLT_PRMRY_CRNCY_CD',NULL,'Default Primary Currency Code',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
620
621 MERGE INTO ddr_r_lkup_mst lkup USING dual
622 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'DFLT_SRC_SYS_IDNT')
623 WHEN NOT MATCHED THEN
624 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
625 VALUES (p_mfg_org,'SYS_PARAM','DFLT_SRC_SYS_IDNT','-1','Default Source System Identifier',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
626
627 MERGE INTO ddr_r_lkup_mst lkup USING dual
628 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'DFLT_BSNS_UNIT_TYP')
629 WHEN NOT MATCHED THEN
630 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
631 VALUES (p_mfg_org,'SYS_PARAM','DFLT_BSNS_UNIT_TYP',NULL,'Default Business Unit Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
632
633
634 MERGE INTO ddr_r_lkup_mst lkup USING dual
635 ON (lkup.lkup_typ_cd = 'TIME_LVL' AND lkup.lkup_cd = 'DAY')
636 WHEN NOT MATCHED THEN
637 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
638 VALUES (p_mfg_org,'TIME_LVL','DAY','Day','Day',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
639
640 MERGE INTO ddr_r_lkup_mst lkup USING dual
641 ON (lkup.lkup_typ_cd = 'TIME_LVL' AND lkup.lkup_cd = 'MONTH')
642 WHEN NOT MATCHED THEN
643 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
644 VALUES (p_mfg_org,'TIME_LVL','MONTH','Month','Month',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
645
646 MERGE INTO ddr_r_lkup_mst lkup USING dual
647 ON (lkup.lkup_typ_cd = 'TIME_LVL' AND lkup.lkup_cd = 'NA')
648 WHEN NOT MATCHED THEN
649 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
650 VALUES (p_mfg_org,'TIME_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
651
652 MERGE INTO ddr_r_lkup_mst lkup USING dual
653 ON (lkup.lkup_typ_cd = 'TIME_LVL' AND lkup.lkup_cd = 'QUARTER')
654 WHEN NOT MATCHED THEN
655 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
656 VALUES (p_mfg_org,'TIME_LVL','QUARTER','Quarter','Quarter',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
657
658 MERGE INTO ddr_r_lkup_mst lkup USING dual
659 ON (lkup.lkup_typ_cd = 'TIME_LVL' AND lkup.lkup_cd = 'WEEK')
660 WHEN NOT MATCHED THEN
661 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
662 VALUES (p_mfg_org,'TIME_LVL','WEEK','Week','Week',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
663
664 MERGE INTO ddr_r_lkup_mst lkup USING dual
665 ON (lkup.lkup_typ_cd = 'TIME_LVL' AND lkup.lkup_cd = 'YEAR')
666 WHEN NOT MATCHED THEN
667 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
668 VALUES (p_mfg_org,'TIME_LVL','YEAR','Year','Year',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
669
670 MERGE INTO ddr_r_lkup_mst lkup USING dual
671 ON (lkup.lkup_typ_cd = 'PRMTN_FLAG' AND lkup.lkup_cd = 'Y')
672 WHEN NOT MATCHED THEN
673 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
674 VALUES (p_mfg_org,'PRMTN_FLAG','Y','Promotion','Promotion Sales',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
675
676 MERGE INTO ddr_r_lkup_mst lkup USING dual
677 ON (lkup.lkup_typ_cd = 'PRMTN_FLAG' AND lkup.lkup_cd = 'N')
678 WHEN NOT MATCHED THEN
679 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
680 VALUES (p_mfg_org,'PRMTN_FLAG','N','Regular','Non Promotion Sales',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
681
682 MERGE INTO ddr_r_lkup_mst lkup USING dual
683 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'RETL_DSR_SRC_DIR')
684 WHEN NOT MATCHED THEN
685 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
686 VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_SRC_DIR',NULL,'Directory location for the data file',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
687
688 MERGE INTO ddr_r_lkup_mst lkup USING dual
689 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'RETL_DSR_SRC_FILENAME')
690 WHEN NOT MATCHED THEN
691 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
692 VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_SRC_FILENAME',NULL,'Name of the data file',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
693
694 MERGE INTO ddr_r_lkup_mst lkup USING dual
695 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'RETL_DSR_SUCCESS_DIR')
696 WHEN NOT MATCHED THEN
697 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
698 VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_SUCCESS_DIR',NULL,'Archive directory for data file after successful data load',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
699
700 MERGE INTO ddr_r_lkup_mst lkup USING dual
701 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'RETL_DSR_FAILED_DIR')
702 WHEN NOT MATCHED THEN
703 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
704 VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_FAILED_DIR',NULL,'Archive directory for data file if data load fails',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
705
709 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
706 MERGE INTO ddr_r_lkup_mst lkup USING dual
707 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'RETL_DSR_TO_ADDR')
708 WHEN NOT MATCHED THEN
710 VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_TO_ADDR',NULL,'To email address for process notifications',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
711
712 MERGE INTO ddr_r_lkup_mst lkup USING dual
713 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'RETL_DSR_FM_ADDR')
714 WHEN NOT MATCHED THEN
715 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
716 VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_FM_ADDR',NULL,'From email address for process notifications',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
717
718 MERGE INTO ddr_r_lkup_mst lkup USING dual
719 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'RETL_DSR_MAIL_SERVER')
720 WHEN NOT MATCHED THEN
721 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
722 VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_MAIL_SERVER',NULL,'Email server for process notifications',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
723
724 MERGE INTO ddr_r_lkup_mst lkup USING dual
725 ON (lkup.lkup_typ_cd = 'SYS_PARAM' AND lkup.lkup_cd = 'RETL_DSR_CLASS_DIR')
726 WHEN NOT MATCHED THEN
727 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
728 VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_CLASS_DIR',NULL,'Directory location for java class files used for RMS integration',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
729
730 MERGE INTO ddr_r_lkup_mst lkup USING dual
731 ON (lkup.lkup_typ_cd = 'ITM_TYP' AND lkup.lkup_cd = 'M')
732 WHEN NOT MATCHED THEN
733 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
734 VALUES (p_mfg_org,'ITM_TYP','M','Manufacturer Item','Item from manufacturer item hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
735
736 MERGE INTO ddr_r_lkup_mst lkup USING dual
737 ON (lkup.lkup_typ_cd = 'ITM_TYP' AND lkup.lkup_cd = 'C')
738 WHEN NOT MATCHED THEN
739 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
740 VALUES (p_mfg_org,'ITM_TYP','C','Competitor Item','Item from competitor item hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
741
742
743 MERGE INTO ddr_r_lkup_mst lkup USING dual
744 ON (lkup.lkup_typ_cd = 'EXCPTN_TYP' AND lkup.lkup_cd = 'FCSTACC')
745 WHEN NOT MATCHED THEN
746 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
747 VALUES (p_mfg_org,'EXCPTN_TYP','FCSTACC','Sales Forecast Accuracy','Sales Forecast Accuracy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
748
749 MERGE INTO ddr_r_lkup_mst lkup USING dual
750 ON (lkup.lkup_typ_cd = 'EXCPTN_TYP' AND lkup.lkup_cd = 'IFPL')
751 WHEN NOT MATCHED THEN
752 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
753 VALUES (p_mfg_org,'EXCPTN_TYP','IFPL','In-flight Promotional Lift','In-flight Promotional Lift',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
754
755 MERGE INTO ddr_r_lkup_mst lkup USING dual
756 ON (lkup.lkup_typ_cd = 'EXCPTN_TYP' AND lkup.lkup_cd = 'NPISALES')
757 WHEN NOT MATCHED THEN
758 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
759 VALUES (p_mfg_org,'EXCPTN_TYP','NPISALES','New Item Not Selling','New Item Not Selling',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
760
761 MERGE INTO ddr_r_lkup_mst lkup USING dual
762 ON (lkup.lkup_typ_cd = 'EXCPTN_TYP' AND lkup.lkup_cd = 'OOSIM')
763 WHEN NOT MATCHED THEN
764 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
765 VALUES (p_mfg_org,'EXCPTN_TYP','OOSIM','Out of Stock Imputed','Out of Stock Imputed',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
766
767 MERGE INTO ddr_r_lkup_mst lkup USING dual
768 ON (lkup.lkup_typ_cd = 'EXCPTN_TYP' AND lkup.lkup_cd = 'OOSOH')
769 WHEN NOT MATCHED THEN
770 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
771 VALUES (p_mfg_org,'EXCPTN_TYP','OOSOH','Out of Stock On Hand','Out of Stock On Hand',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
772
773 MERGE INTO ddr_r_lkup_mst lkup USING dual
774 ON (lkup.lkup_typ_cd = 'EXCPTN_TYP' AND lkup.lkup_cd = 'OVRSTCK')
775 WHEN NOT MATCHED THEN
779
776 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
777 VALUES (p_mfg_org,'EXCPTN_TYP','OVRSTCK','Overstock','Overstock',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
778
780 MERGE INTO ddr_r_lkup_mst lkup USING dual
781 ON (lkup.lkup_typ_cd = 'EXCPTN_TYP' AND lkup.lkup_cd = 'PPD')
782 WHEN NOT MATCHED THEN
783 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
784 VALUES (p_mfg_org,'EXCPTN_TYP','PPD','Promotional Price','Promotional Price',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
785
786
787 MERGE INTO ddr_r_lkup_mst lkup USING dual
788 ON (lkup.lkup_typ_cd = 'EXCPTN_TYP' AND lkup.lkup_cd = 'REORDR')
789 WHEN NOT MATCHED THEN
790 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
791 VALUES (p_mfg_org,'EXCPTN_TYP','REORDR','Reorder Point','Reorder Point',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
792
793 MERGE INTO ddr_r_lkup_mst lkup USING dual
794 ON (lkup.lkup_typ_cd = 'FRCST_TYP' AND lkup.lkup_cd = 'BASE')
795 WHEN NOT MATCHED THEN
796 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
797 VALUES (p_mfg_org,'FRCST_TYP','BASE','BASE','BASE',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
798
799 MERGE INTO ddr_r_lkup_mst lkup USING dual
800 ON (lkup.lkup_typ_cd = 'FRCST_TYP' AND lkup.lkup_cd = 'PROMO')
801 WHEN NOT MATCHED THEN
802 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
803 VALUES (p_mfg_org,'FRCST_TYP','PROMO','PROMO','PROMO',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
804
805 MERGE INTO ddr_r_lkup_mst lkup USING dual
806 ON (lkup.lkup_typ_cd = 'FRCST_TYP' AND lkup.lkup_cd = 'TOTAL')
807 WHEN NOT MATCHED THEN
808 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
809 VALUES (p_mfg_org,'FRCST_TYP','TOTAL','TOTAL','TOTAL',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
810
811 MERGE INTO ddr_r_lkup_mst lkup USING dual
812 ON (lkup.lkup_typ_cd = 'FRCST_PURP' AND lkup.lkup_cd = 'SALES')
813 WHEN NOT MATCHED THEN
814 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
815 VALUES (p_mfg_org,'FRCST_PURP','SALES','SALES','SALES',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
816
817 MERGE INTO ddr_r_lkup_mst lkup USING dual
821 VALUES (p_mfg_org,'FRCST_PURP','ORDERS','ORDERS','ORDERS',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
818 ON (lkup.lkup_typ_cd = 'FRCST_PURP' AND lkup.lkup_cd = 'ORDERS')
819 WHEN NOT MATCHED THEN
820 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
822
823 MERGE INTO ddr_r_lkup_mst lkup USING dual
824 ON (lkup.lkup_typ_cd = 'FRCST_PURP' AND lkup.lkup_cd = 'SHIPMENT')
825 WHEN NOT MATCHED THEN
826 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
827 VALUES (p_mfg_org,'FRCST_PURP','SHIPMENT','SHIPMENT','SHIPMENT',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
828
832 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
829 MERGE INTO ddr_r_lkup_mst lkup USING dual
830 ON (lkup.lkup_typ_cd = 'FRCST_PURP' AND lkup.lkup_cd = 'RECEIPTS')
831 WHEN NOT MATCHED THEN
833 VALUES (p_mfg_org,'FRCST_PURP','RECEIPTS','RECEIPTS','RECEIPTS',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
834
835 MERGE INTO ddr_r_lkup_mst lkup USING dual
836 ON (lkup.lkup_typ_cd = 'SLS_TYP' AND lkup.lkup_cd = '1')
837 WHEN NOT MATCHED THEN
838 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
839 VALUES (p_mfg_org,'SLS_TYP','1','Manufacturer Promoted','POS Sales that were identified by the customer as promotional sales and have been associated to a manufacturer promotion',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
840
841 MERGE INTO ddr_r_lkup_mst lkup USING dual
842 ON (lkup.lkup_typ_cd = 'SLS_TYP' AND lkup.lkup_cd = '2')
843 WHEN NOT MATCHED THEN
844 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
845 VALUES (p_mfg_org,'SLS_TYP','2','Manufacturer Non Compliant',
846 'POS Sales that were identified by the customer as regular (non-promotional) sales but according to the manufacturer promotion plan criteria should have been promoted',
847 v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
848
849 MERGE INTO ddr_r_lkup_mst lkup USING dual
850 ON (lkup.lkup_typ_cd = 'SLS_TYP' AND lkup.lkup_cd = '3')
851 WHEN NOT MATCHED THEN
852 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
853 VALUES (p_mfg_org,'SLS_TYP','3','Other Promoted','POS Sales that were identified by the customer as promotional sales but there is no associated manufacturer promotion',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
854
855 MERGE INTO ddr_r_lkup_mst lkup USING dual
856 ON (lkup.lkup_typ_cd = 'SLS_TYP' AND lkup.lkup_cd = '4')
857 WHEN NOT MATCHED THEN
858 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
859 VALUES (p_mfg_org,'SLS_TYP','4','Regular','POS Sales that were identified by the customer as regular (non-promotional) sales and there is no associated manufacturer promotion',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
860
861 MERGE INTO ddr_r_lkup_mst lkup USING dual
862 ON (lkup.lkup_typ_cd = 'HCHY_TYPE' AND lkup.lkup_cd = 'MFG_ITEM')
863 WHEN NOT MATCHED THEN
864 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
865 ,last_update_login)
866 VALUES (p_mfg_org,'HCHY_TYPE','MFG_ITEM','Manufacturer Item Hierarchy','Manufacturer Item Hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
867
868 MERGE INTO ddr_r_lkup_mst lkup USING dual
869 ON (lkup.lkup_typ_cd = 'HCHY_TYPE' AND lkup.lkup_cd = 'RTL_ITEM')
870 WHEN NOT MATCHED THEN
871 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
872 ,last_update_login)
873 VALUES (p_mfg_org,'HCHY_TYPE','RTL_ITEM','Retailer Item Hierarchy','Retailer Item Hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
874
875 MERGE INTO ddr_r_lkup_mst lkup USING dual
876 ON (lkup.lkup_typ_cd = 'HCHY_TYPE' AND lkup.lkup_cd = 'ORG')
877 WHEN NOT MATCHED THEN
878 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
879 ,last_update_login)
880 VALUES (p_mfg_org,'HCHY_TYPE','ORG','Organization Hierarchy','Organization Hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
881
882 MERGE INTO ddr_r_lkup_mst lkup USING dual
883 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'CMPNY')
884 WHEN NOT MATCHED THEN
885 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
886 ,last_update_login)
887 VALUES (p_mfg_org,'HCHY_LVL','CMPNY','Company','Company',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
888
889 MERGE INTO ddr_r_lkup_mst lkup USING dual
890 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'DIV')
891 WHEN NOT MATCHED THEN
892 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
893 ,last_update_login)
894 VALUES (p_mfg_org,'HCHY_LVL','DIV','Division','Division',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
895
896 MERGE INTO ddr_r_lkup_mst lkup USING dual
897 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'CLASS')
898 WHEN NOT MATCHED THEN
899 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
900 ,last_update_login)
901 VALUES (p_mfg_org,'HCHY_LVL','CLASS','Class','Class',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
902
903 MERGE INTO ddr_r_lkup_mst lkup USING dual
904 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'SBC')
905 WHEN NOT MATCHED THEN
909
906 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
907 ,last_update_login)
908 VALUES (p_mfg_org,'HCHY_LVL','SBC','Sub-Class','Sub-Class',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
910 MERGE INTO ddr_r_lkup_mst lkup USING dual
911 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'GRP')
912 WHEN NOT MATCHED THEN
913 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
914 ,last_update_login)
915 VALUES (p_mfg_org,'HCHY_LVL','GRP','Group','Group',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
916
917 MERGE INTO ddr_r_lkup_mst lkup USING dual
918 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'ITEM')
919 WHEN NOT MATCHED THEN
920 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
921 ,last_update_login)
922 VALUES (p_mfg_org,'HCHY_LVL','ITEM','Item','Item',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
923
924 MERGE INTO ddr_r_lkup_mst lkup USING dual
925 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'DEPT')
926 WHEN NOT MATCHED THEN
927 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
928 ,last_update_login)
929 VALUES (p_mfg_org,'HCHY_LVL','DEPT','Department','Department',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
930
931 MERGE INTO ddr_r_lkup_mst lkup USING dual
932 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'CHAIN')
933 WHEN NOT MATCHED THEN
934 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
935 ,last_update_login)
936 VALUES (p_mfg_org,'HCHY_LVL','CHAIN','Chain','Chain',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
937
938 MERGE INTO ddr_r_lkup_mst lkup USING dual
939 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'AREA')
940 WHEN NOT MATCHED THEN
941 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
942 ,last_update_login)
943 VALUES (p_mfg_org,'HCHY_LVL','AREA','Area','Area',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
944
945 MERGE INTO ddr_r_lkup_mst lkup USING dual
946 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'RGN')
947 WHEN NOT MATCHED THEN
948 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
949 ,last_update_login)
950 VALUES (p_mfg_org,'HCHY_LVL','RGN','Region','Region',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
951
952 MERGE INTO ddr_r_lkup_mst lkup USING dual
953 ON (lkup.lkup_typ_cd = 'HCHY_LVL' AND lkup.lkup_cd = 'DSTRCT')
954 WHEN NOT MATCHED THEN
955 INSERT (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date
956 ,last_update_login)
957 VALUES (p_mfg_org,'HCHY_LVL','DSTRCT','District','District',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
958
959
960 END setup_lookup;
961
962 PROCEDURE setup_ws_metadata IS
963 BEGIN
964 --DELETE ddr_ws_metadata;
965 MERGE INTO ddr_ws_metadata ws USING dual
966 ON (ws.hrchy_lvl_cd='MFG_CLASS_CD' AND hrchy_lvl_name='ITEM')
967 WHEN NOT MATCHED THEN
968 INSERT
969 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
970 VALUES
971 ('MFG_CLASS_CD', 'ITEM', 'Item Class', 4, NULL,
972 'Y', 'Y', -1, SYSDATE, '-1',
973 SYSDATE, '-1', v_version, SYSDATE, '-1',
974 '-1');
975
976 MERGE INTO ddr_ws_metadata ws USING dual
977 ON (ws.hrchy_lvl_cd='MFG_SBC_CD' AND hrchy_lvl_name='ITEM')
978 WHEN NOT MATCHED THEN
979 INSERT
980 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
981 VALUES
982 ('MFG_SBC_CD', 'ITEM', 'Item SubClass', 3, NULL,
983 'Y', 'Y', -1, SYSDATE, '-1',
984 SYSDATE, '-1', v_version, SYSDATE, '-1',
985 '-1');
986
987 MERGE INTO ddr_ws_metadata ws USING dual
988 ON (ws.hrchy_lvl_cd='MFG_ITEM_NBR' AND hrchy_lvl_name='ITEM')
989 WHEN NOT MATCHED THEN
990 INSERT
991 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
992 VALUES
993 ('MFG_ITEM_NBR', 'ITEM', 'Item Number', 2, NULL,
994 'Y', 'N', -1, SYSDATE, '-1',
995 SYSDATE, '-1', v_version, SYSDATE, '-1',
996 '-1');
997
998 MERGE INTO ddr_ws_metadata ws USING dual
999 ON (ws.hrchy_lvl_cd='MFG_SKU_ITEM_NBR' AND hrchy_lvl_name='ITEM')
1000 WHEN NOT MATCHED THEN
1001 INSERT
1005 'Y', 'Y', -1, SYSDATE, '-1',
1002 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1003 VALUES
1004 ('MFG_SKU_ITEM_NBR', 'ITEM', 'Sku Item Number', 1, NULL,
1006 SYSDATE, '-1', v_version, SYSDATE, '-1',
1007 '-1');
1008
1009 MERGE INTO ddr_ws_metadata ws USING dual
1010 ON (ws.hrchy_lvl_cd='MFG_DIV_CD' AND hrchy_lvl_name='ITEM')
1011 WHEN NOT MATCHED THEN
1012 INSERT
1013 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1014 VALUES
1015 ('MFG_DIV_CD', 'ITEM', 'Item Division', 6, NULL,
1016 'Y', 'N', -1, SYSDATE, '-1',
1017 SYSDATE, '-1', v_version, SYSDATE, '-1',
1018 '-1');
1019
1020 MERGE INTO ddr_ws_metadata ws USING dual
1021 ON (ws.hrchy_lvl_cd='MFG_GRP_CD' AND hrchy_lvl_name='ITEM')
1022 WHEN NOT MATCHED THEN
1023 INSERT
1024 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1025 VALUES
1026 ('MFG_GRP_CD', 'ITEM', 'Item Group', 5, NULL,
1027 'Y', 'N', -1, SYSDATE, '-1',
1028 SYSDATE, '-1', v_version, SYSDATE, '-1',
1029 '-1');
1030
1031 MERGE INTO ddr_ws_metadata ws USING dual
1032 ON (ws.hrchy_lvl_cd='CLSTR_CD' AND hrchy_lvl_name='ORGANIZATION')
1033 WHEN NOT MATCHED THEN
1034 INSERT
1035 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1036 VALUES
1037 ('CLSTR_CD', 'ORGANIZATION', 'Organization Retail Cluster', 7, NULL,
1038 'Y', 'N', -1, SYSDATE, '-1',
1039 SYSDATE, '-1', v_version, SYSDATE, '-1',
1040 '-1');
1041
1042 MERGE INTO ddr_ws_metadata ws USING dual
1043 ON (ws.hrchy_lvl_cd='ORG_CD' AND hrchy_lvl_name='ORGANIZATION')
1044 WHEN NOT MATCHED THEN
1045 INSERT
1046 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1047 VALUES
1048 ('ORG_CD', 'ORGANIZATION', 'Organization Retail Org', 6, NULL,
1049 'Y', 'N', -1, SYSDATE, '-1',
1050 SYSDATE, '-1', v_version, SYSDATE, '-1',
1051 '-1');
1052
1053 MERGE INTO ddr_ws_metadata ws USING dual
1054 ON (ws.hrchy_lvl_cd='CHAIN_CD' AND hrchy_lvl_name='ORGANIZATION')
1055 WHEN NOT MATCHED THEN
1056 INSERT
1057 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1058 VALUES
1059 ('CHAIN_CD', 'ORGANIZATION', 'Organization Retail Chain', 5, NULL,
1060 'Y', 'N', -1, SYSDATE, '-1',
1061 SYSDATE, '-1', v_version, SYSDATE, '-1',
1062 '-1');
1063
1064 MERGE INTO ddr_ws_metadata ws USING dual
1065 ON (ws.hrchy_lvl_cd='AREA_CD' AND hrchy_lvl_name='ORGANIZATION')
1066 WHEN NOT MATCHED THEN
1067 INSERT
1068 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1069 VALUES
1070 ('AREA_CD', 'ORGANIZATION', 'Organization Retail Area', 4, NULL,
1071 'N', 'N', -1, SYSDATE, '-1',
1072 SYSDATE, '-1', v_version, SYSDATE, '-1',
1073 '-1');
1074
1075 MERGE INTO ddr_ws_metadata ws USING dual
1076 ON (ws.hrchy_lvl_cd='RGN_CD' AND hrchy_lvl_name='ORGANIZATION')
1077 WHEN NOT MATCHED THEN
1078 INSERT
1079 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1080 VALUES
1081 ('RGN_CD', 'ORGANIZATION', 'Organization Retail Region', 3, NULL,
1082 'N', 'N', -1, SYSDATE, '-1',
1083 SYSDATE, '-1', v_version, SYSDATE, '-1',
1084 '-1');
1085
1086 MERGE INTO ddr_ws_metadata ws USING dual
1087 ON (ws.hrchy_lvl_cd='DSTRCT_CD' AND hrchy_lvl_name='ORGANIZATION')
1088 WHEN NOT MATCHED THEN
1089 INSERT
1090 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1091 VALUES
1092 ('DSTRCT_CD', 'ORGANIZATION', 'Organization Retail District', 2, NULL,
1093 'N', 'N', -1, SYSDATE, '-1',
1094 SYSDATE, '-1', v_version, SYSDATE, '-1',
1095 '-1');
1096
1097 MERGE INTO ddr_ws_metadata ws USING dual
1098 ON (ws.hrchy_lvl_cd='BSNS_UNIT_CD' AND hrchy_lvl_name='ORGANIZATION')
1099 WHEN NOT MATCHED THEN
1100 INSERT
1101 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1102 VALUES
1103 ('BSNS_UNIT_CD', 'ORGANIZATION', 'Organization Retail Bus. Unit', 1, NULL,
1104 'N', 'N', -1, SYSDATE, '-1',
1105 SYSDATE, '-1', v_version, SYSDATE, '-1',
1106 '-1');
1107
1108 MERGE INTO ddr_ws_metadata ws USING dual
1112 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1109 ON (ws.hrchy_lvl_cd='INV_LOC_CD' AND hrchy_lvl_name='ORGANIZATION')
1110 WHEN NOT MATCHED THEN
1111 INSERT
1113 VALUES
1114 ('INV_LOC_CD', 'ORGANIZATION', 'Organization Inventory Level', 0, NULL,
1115 'Y', 'N', -1, SYSDATE, '-1',
1116 SYSDATE, '-1', v_version, SYSDATE, '-1',
1117 '-1');
1118
1119 MERGE INTO ddr_ws_metadata ws USING dual
1120 ON (ws.hrchy_lvl_cd='CNTRY_CD' AND hrchy_lvl_name='LOCATION')
1121 WHEN NOT MATCHED THEN
1122 INSERT
1123 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1124 VALUES
1125 ('CNTRY_CD', 'LOCATION', 'Location Country', 3, NULL,
1126 'N', 'N', -1, SYSDATE, '-1',
1127 SYSDATE, '-1', v_version, SYSDATE, '-1',
1128 '-1');
1129
1130 MERGE INTO ddr_ws_metadata ws USING dual
1131 ON (ws.hrchy_lvl_cd='STATE_CD' AND hrchy_lvl_name='LOCATION')
1132 WHEN NOT MATCHED THEN
1133 INSERT
1134 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1135 VALUES
1136 ('STATE_CD', 'LOCATION', 'Location State', 2, NULL,
1137 'N', 'N', -1, SYSDATE, '-1',
1138 SYSDATE, '-1', v_version, SYSDATE, '-1',
1139 '-1');
1140
1141 MERGE INTO ddr_ws_metadata ws USING dual
1142 ON (ws.hrchy_lvl_cd='CITY_CD' AND hrchy_lvl_name='LOCATION')
1143 WHEN NOT MATCHED THEN
1144 INSERT
1145 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1146 VALUES
1147 ('CITY_CD', 'LOCATION', 'Location City', 1, NULL,
1148 'N', 'N', -1, SYSDATE, '-1',
1149 SYSDATE, '-1', v_version, SYSDATE, '-1',
1150 '-1');
1151
1152 MERGE INTO ddr_ws_metadata ws USING dual
1153 ON (ws.hrchy_lvl_cd='CLNDR_YR_CD' AND hrchy_lvl_name='GREGORIAN TIME')
1154 WHEN NOT MATCHED THEN
1155 INSERT
1156 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1157 VALUES
1158 ('CLNDR_YR_CD', 'GREGORIAN TIME', 'Calander Year', 5, NULL,
1159 'Y', 'N', -1, SYSDATE, '-1',
1160 SYSDATE, '-1', v_version, SYSDATE, '-1',
1161 '-1');
1162
1163 MERGE INTO ddr_ws_metadata ws USING dual
1164 ON (ws.hrchy_lvl_cd='CLNDR_QTR_CD' AND hrchy_lvl_name='GREGORIAN TIME')
1165 WHEN NOT MATCHED THEN
1166 INSERT
1167 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1168 VALUES
1169 ('CLNDR_QTR_CD', 'GREGORIAN TIME', 'Calander Quarter', 4, NULL,
1170 'Y', 'N', -1, SYSDATE, '-1',
1171 SYSDATE, '-1', v_version, SYSDATE, '-1',
1172 '-1');
1173
1174 MERGE INTO ddr_ws_metadata ws USING dual
1175 ON (ws.hrchy_lvl_cd='CLNDR_MNTH_CD' AND hrchy_lvl_name='GREGORIAN TIME')
1176 WHEN NOT MATCHED THEN
1177 INSERT
1178 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1179 VALUES
1180 ('CLNDR_MNTH_CD', 'GREGORIAN TIME', 'Calander Month', 3, NULL,
1181 'Y', 'N', -1, SYSDATE, '-1',
1182 SYSDATE, '-1', v_version, SYSDATE, '-1',
1183 '-1');
1184
1185 MERGE INTO ddr_ws_metadata ws USING dual
1186 ON (ws.hrchy_lvl_cd='CLNDR_WK_CD' AND hrchy_lvl_name='GREGORIAN TIME')
1187 WHEN NOT MATCHED THEN
1188 INSERT
1189 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1190 VALUES
1191 ('CLNDR_WK_CD', 'GREGORIAN TIME', 'Calander Week', 2, NULL,
1192 'Y', 'N', -1, SYSDATE, '-1',
1193 SYSDATE, '-1', v_version, SYSDATE, '-1',
1194 '-1');
1195
1196 MERGE INTO ddr_ws_metadata ws USING dual
1197 ON (ws.hrchy_lvl_cd='CLNDR_DAY_CD' AND hrchy_lvl_name='GREGORIAN TIME')
1198 WHEN NOT MATCHED THEN
1199 INSERT
1200 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1201 VALUES
1202 ('CLNDR_DAY_CD', 'GREGORIAN TIME', 'Calander Day', 1, NULL,
1203 'Y', 'Y', -1, SYSDATE, '-1',
1204 SYSDATE, '-1', v_version, SYSDATE, '-1',
1205 '-1');
1206
1207 MERGE INTO ddr_ws_metadata ws USING dual
1208 ON (ws.hrchy_lvl_cd='BSNS_YR_CD' AND hrchy_lvl_name='BUSINESS TIME')
1209 WHEN NOT MATCHED THEN
1210 INSERT
1211 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1215 SYSDATE, '-1', v_version, SYSDATE, '-1',
1212 VALUES
1213 ('BSNS_YR_CD', 'BUSINESS TIME', 'Business Year', 5, NULL,
1214 'Y', 'N', -1, SYSDATE, '-1',
1216 '-1');
1217
1218 MERGE INTO ddr_ws_metadata ws USING dual
1219 ON (ws.hrchy_lvl_cd='BSNS_QTR_CD' AND hrchy_lvl_name='BUSINESS TIME')
1220 WHEN NOT MATCHED THEN
1221 INSERT
1222 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1223 VALUES
1224 ('BSNS_QTR_CD', 'BUSINESS TIME', 'Business Quarter', 4, NULL,
1225 'Y', 'N', -1, SYSDATE, '-1',
1226 SYSDATE, '-1', v_version, SYSDATE, '-1',
1227 '-1');
1228
1229 MERGE INTO ddr_ws_metadata ws USING dual
1230 ON (ws.hrchy_lvl_cd='BSNS_MNTH_CD' AND hrchy_lvl_name='BUSINESS TIME')
1231 WHEN NOT MATCHED THEN
1232 INSERT
1233 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1234 VALUES
1235 ('BSNS_MNTH_CD', 'BUSINESS TIME', 'Business Month', 3, NULL,
1236 'Y', 'N', -1, SYSDATE, '-1',
1237 SYSDATE, '-1', v_version, SYSDATE, '-1',
1238 '-1');
1239
1240 MERGE INTO ddr_ws_metadata ws USING dual
1241 ON (ws.hrchy_lvl_cd='BSNS_DAY_CD' AND hrchy_lvl_name='BUSINESS TIME')
1242 WHEN NOT MATCHED THEN
1243 INSERT
1244 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1245 VALUES
1246 ('BSNS_DAY_CD', 'BUSINESS TIME', 'Business Day', 1, NULL,
1247 'Y', 'N', -1, SYSDATE, '-1',
1248 SYSDATE, '-1', v_version, SYSDATE, '-1',
1249 '-1');
1250
1251 MERGE INTO ddr_ws_metadata ws USING dual
1252 ON (ws.hrchy_lvl_cd='BSNS_WK_CD' AND hrchy_lvl_name='BUSINESS TIME')
1253 WHEN NOT MATCHED THEN
1254 INSERT
1255 (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
1256 VALUES
1257 ('BSNS_WK_CD', 'BUSINESS TIME', 'Business Week', 2, 1,
1258 'Y', 'Y', -1, SYSDATE, '-1',
1259 SYSDATE, '-1', v_version, SYSDATE, '-1',
1260 '-1');
1261 END setup_ws_metadata;
1262
1263 PROCEDURE setup_lookup_type IS
1264 BEGIN
1265 --DELETE ddr_r_lkup_typ;
1266 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1267 ON(lkup_typ_cd='ADDR_TYP')
1268 WHEN NOT MATCHED THEN
1269 INSERT
1270 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1271 VALUES ('ADDR_TYP','Address Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1272
1273 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1274 ON(lkup_typ_cd='BRND')
1275 WHEN NOT MATCHED THEN
1276 INSERT
1277 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1278 VALUES ('BRND','Item Brand',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1279
1280 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1281 ON(lkup_typ_cd='BSNS_UNIT_TYP')
1282 WHEN NOT MATCHED THEN
1283 INSERT
1284 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1285 VALUES ('BSNS_UNIT_TYP','Business Unit Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1286
1287 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1288 ON(lkup_typ_cd='CHNL_TYP')
1289 WHEN NOT MATCHED THEN
1290 INSERT
1291 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1292 VALUES ('CHNL_TYP','Channel Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1293
1294 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1295 ON(lkup_typ_cd='COATING')
1296 WHEN NOT MATCHED THEN
1297 INSERT
1298 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1299 VALUES ('COATING','Coating Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1300
1301 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1302 ON(lkup_typ_cd='COLOR')
1303 WHEN NOT MATCHED THEN
1304 INSERT
1305 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1306 VALUES ('COLOR','Color',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1307
1308 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1309 ON(lkup_typ_cd='DYE')
1310 WHEN NOT MATCHED THEN
1311 INSERT
1312 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1313 VALUES ('DYE','Dye',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1314
1315 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1319 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1316 ON(lkup_typ_cd='ERR')
1317 WHEN NOT MATCHED THEN
1318 INSERT
1320 VALUES ('ERR','Error',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1321
1322 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1323 ON(lkup_typ_cd='FABRIC')
1324 WHEN NOT MATCHED THEN
1325 INSERT
1326 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1327 VALUES ('FABRIC','Fabric',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1328
1329 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1330 ON(lkup_typ_cd='FIBER')
1331 WHEN NOT MATCHED THEN
1332 INSERT
1333 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1334 VALUES ('FIBER','Fiber',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1335
1336 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1337 ON(lkup_typ_cd='GIID_TYP')
1338 WHEN NOT MATCHED THEN
1339 INSERT
1340 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1341 VALUES ('GIID_TYP','GIID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1342
1343 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1344 ON(lkup_typ_cd='GLID_TYP')
1345 WHEN NOT MATCHED THEN
1346 INSERT
1347 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1348 VALUES ('GLID_TYP','GLID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1349
1350 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1351 ON(lkup_typ_cd='MEASURE')
1352 WHEN NOT MATCHED THEN
1353 INSERT
1354 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1355 VALUES ('MEASURE','Measure Name',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1356
1357 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1358 ON(lkup_typ_cd='MEASURE_TYP')
1359 WHEN NOT MATCHED THEN
1360 INSERT
1361 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1362 VALUES ('MEASURE_TYP','Measure Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1363
1364 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1365 ON(lkup_typ_cd='MFG_ITEM_LVL')
1366 WHEN NOT MATCHED THEN
1367 INSERT
1368 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1369 VALUES ('MFG_ITEM_LVL','Mfg Item Level Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1370
1371 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1372 ON(lkup_typ_cd='ORG_LVL')
1373 WHEN NOT MATCHED THEN
1374 INSERT
1375 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1376 VALUES ('ORG_LVL','Organization Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1377
1381 INSERT
1378 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1379 ON(lkup_typ_cd='ORG_TYP')
1380 WHEN NOT MATCHED THEN
1382 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1383 VALUES ('ORG_TYP','Organization Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1384
1385 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1386 ON(lkup_typ_cd='RPLNSHMNT_TYP')
1387 WHEN NOT MATCHED THEN
1388 INSERT
1389 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1390 VALUES ('RPLNSHMNT_TYP','Replenishment Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1391
1392 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1393 ON(lkup_typ_cd='RTL_ITEM_LVL')
1394 WHEN NOT MATCHED THEN
1395 INSERT
1396 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1397 VALUES ('RTL_ITEM_LVL','Retailer Item Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1398
1399 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1400 ON(lkup_typ_cd='RTL_TYP')
1401 WHEN NOT MATCHED THEN
1402 INSERT
1403 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1404 VALUES ('RTL_TYP','Retail Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1405
1406 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1407 ON(lkup_typ_cd='SKU_ITEM_STYLE')
1408 WHEN NOT MATCHED THEN
1409 INSERT
1410 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1411 VALUES ('SKU_ITEM_STYLE','SKU Item Style',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1412
1413 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1414 ON(lkup_typ_cd='SKU_ITEM_TYP')
1415 WHEN NOT MATCHED THEN
1416 INSERT
1417 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1418 VALUES ('SKU_ITEM_TYP','SKU Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1419
1420 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1421 ON(lkup_typ_cd='SLNG_LOC_TYP')
1422 WHEN NOT MATCHED THEN
1423 INSERT
1424 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1425 VALUES ('SLNG_LOC_TYP','Selling Location Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1426
1427 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1428 ON(lkup_typ_cd='STCK_ITEM_TYP')
1429 WHEN NOT MATCHED THEN
1430 INSERT
1431 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1432 VALUES ('STCK_ITEM_TYP','Stock Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1433
1434 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1435 ON(lkup_typ_cd='SYS_PARAM')
1436 WHEN NOT MATCHED THEN
1437 INSERT
1438 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1439 VALUES ('SYS_PARAM','System Parameter',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1440
1441 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1442 ON(lkup_typ_cd='SZ_TYP')
1443 WHEN NOT MATCHED THEN
1444 INSERT
1445 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1446 VALUES ('SZ_TYP','Size Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1447
1448 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1449 ON(lkup_typ_cd='TIME_LVL')
1450 WHEN NOT MATCHED THEN
1451 INSERT
1452 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1453 VALUES ('TIME_LVL','Time Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1454
1455 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1456 ON(lkup_typ_cd='VRTY_TYP')
1457 WHEN NOT MATCHED THEN
1458 INSERT
1459 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1460 VALUES ('VRTY_TYP','Variety Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1461
1462 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1463 ON(lkup_typ_cd='WEAVE')
1464 WHEN NOT MATCHED THEN
1465 INSERT
1466 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1467 VALUES ('WEAVE','Weave Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1468
1469 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1470 ON(lkup_typ_cd='PRMTN_FLAG')
1471 WHEN NOT MATCHED THEN
1472 INSERT
1473 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1474 VALUES ('PRMTN_FLAG','Promotion Flag',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1475
1476 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1480 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1477 ON(lkup_typ_cd='MKT_AREA_TYP')
1478 WHEN NOT MATCHED THEN
1479 INSERT
1481 VALUES ('MKT_AREA_TYP','Market Area Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1482
1483 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1484 ON(lkup_typ_cd='ITM_TYP')
1485 WHEN NOT MATCHED THEN
1486 INSERT
1487 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1488 VALUES ('ITM_TYP','Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1489
1490 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1491 ON(lkup_typ_cd='EXCPTN_TYP')
1492 WHEN NOT MATCHED THEN
1493 INSERT
1494 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1495 VALUES ('EXCPTN_TYP','Exception Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1496
1497
1498 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1499 ON(lkup_typ_cd='STR_ACV_RANGE')
1500 WHEN NOT MATCHED THEN
1501 INSERT
1502 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1503 VALUES ('STR_ACV_RANGE','Store ACV Range',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1504
1505 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1506 ON(lkup_typ_cd='CMPNY_SIZE')
1507 WHEN NOT MATCHED THEN
1508 INSERT
1509 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1510 VALUES ('CMPNY_SIZE','Company Size',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1511
1512 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1513 ON(lkup_typ_cd='SUB_CHNL_TYP')
1514 WHEN NOT MATCHED THEN
1515 INSERT
1516 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1517 VALUES ('SUB_CHNL_TYP','Sub Channel Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1518
1519 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1520 ON(lkup_typ_cd='SRC_TYP')
1521 WHEN NOT MATCHED THEN
1522 INSERT
1523 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1524 VALUES ('SRC_TYP','Source Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1525
1526 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1527 ON(lkup_typ_cd='MSR_SET')
1528 WHEN NOT MATCHED THEN
1529 INSERT
1530 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1531 VALUES ('MSR_SET','Measure Set',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1532
1533 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1534 ON(lkup_typ_cd='STR_CLSTR_TYP')
1535 WHEN NOT MATCHED THEN
1536 INSERT
1537 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1538 VALUES ('STR_CLSTR_TYP','Store Cluster Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1539
1540 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1541 ON(lkup_typ_cd='FRCST_PURP')
1542 WHEN NOT MATCHED THEN
1543 INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1544 VALUES('FRCST_PURP','Forecast Purpose',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1545
1546 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1547 ON(lkup_typ_cd='FRCST_TYP')
1548 WHEN NOT MATCHED THEN
1549 INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1550 VALUES('FRCST_TYP','Forecast Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1551
1552
1553 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1554 ON(lkup_typ_cd='SLS_TYP')
1555 WHEN NOT MATCHED THEN
1556 INSERT
1557 (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1558 VALUES ('SLS_TYP','Sales Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1559
1560 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1561 ON(lkup_typ_cd='HCHY_TYPE')
1562 WHEN NOT MATCHED THEN
1563 INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1564 VALUES ('HCHY_TYPE','Additional Attributed Hierarchy Types',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1565
1566 MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1567 ON(lkup_typ_cd='HCHY_LVL')
1568 WHEN NOT MATCHED THEN
1569 INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1570 VALUES ('HCHY_LVL','Additional Attributed Hierarchy Levels',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1571
1572 END setup_lookup_type;
1573 END ddr_setup_util;