eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DDR_SETUP_UTIL dependencies on DUAL

Line 48: MERGE INTO ddr_r_lkup_mst lkup USING dual

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:

Line 53: 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:

Line 58: 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:

Line 63: 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');

Line 69: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 76: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 83: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 89: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 95: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 101: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 107: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 113: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 119: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 125: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 131: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 137: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 143: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 149: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 155: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 161: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 167: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 174: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 180: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 186: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 192: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 199: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 205: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)
209: VALUES (p_mfg_org,'MEASURE','GROSS MARGIN','Gross Margin','Gross Margin',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line 211: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)
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
212: ON (lkup.lkup_typ_cd = 'MEASURE' AND lkup.lkup_cd = 'IN STOCK %')
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');

Line 217: 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');

Line 223: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 229: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 235: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 241: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 247: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 254: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 260: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 266: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 272: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 278: MERGE INTO ddr_r_lkup_mst lkup USING dual

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
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)
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');

Line 284: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)
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');
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');

Line 290: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 296: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 302: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 308: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 314: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 320: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 326: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 332: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 338: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 344: MERGE INTO ddr_r_lkup_mst lkup USING dual

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
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');

Line 350: MERGE INTO ddr_r_lkup_mst lkup USING dual

346: WHEN NOT MATCHED THEN
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:
350: MERGE INTO ddr_r_lkup_mst lkup USING dual
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');

Line 356: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 362: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 368: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 374: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 380: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 386: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 392: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 398: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 404: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 410: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 416: MERGE INTO ddr_r_lkup_mst lkup USING dual

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
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');

Line 422: MERGE INTO ddr_r_lkup_mst lkup USING dual

418: WHEN NOT MATCHED THEN
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:
422: MERGE INTO ddr_r_lkup_mst lkup USING dual
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');

Line 428: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 434: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 440: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 446: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 452: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 458: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 464: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 470: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 476: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 483: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 490: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)
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');

Line 496: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)
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
497: ON (lkup.lkup_typ_cd = 'RTL_ITEM_LVL' AND lkup.lkup_cd = 'COMPANY')
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');

Line 502: 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');

Line 508: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 514: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 521: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 527: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 533: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 539: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 545: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 551: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 557: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 563: MERGE INTO ddr_r_lkup_mst lkup USING dual

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
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');

Line 569: MERGE INTO ddr_r_lkup_mst lkup USING dual

565: WHEN NOT MATCHED THEN
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:
569: MERGE INTO ddr_r_lkup_mst lkup USING dual
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

Line 576: MERGE INTO ddr_r_lkup_mst lkup USING dual

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'

Line 583: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 589: MERGE INTO ddr_r_lkup_mst lkup USING dual

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

Line 597: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 603: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 609: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 615: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 621: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 627: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 634: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 640: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 646: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 652: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 658: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 664: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 670: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 676: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 682: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 688: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 694: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 700: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 706: MERGE INTO ddr_r_lkup_mst lkup USING dual

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:
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
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)
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');

Line 712: MERGE INTO ddr_r_lkup_mst lkup USING dual

708: WHEN NOT MATCHED THEN
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)
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');

Line 718: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 724: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 730: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 736: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 743: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 749: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 755: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 761: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 767: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 773: MERGE INTO ddr_r_lkup_mst lkup USING dual

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
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');

Line 780: MERGE INTO ddr_r_lkup_mst lkup USING dual

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:
779:
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');

Line 787: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 793: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 799: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 805: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 811: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 817: MERGE INTO ddr_r_lkup_mst lkup USING dual

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
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)
821: VALUES (p_mfg_org,'FRCST_PURP','ORDERS','ORDERS','ORDERS',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line 823: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)
821: VALUES (p_mfg_org,'FRCST_PURP','ORDERS','ORDERS','ORDERS',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
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');

Line 829: MERGE INTO ddr_r_lkup_mst lkup USING dual

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:
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
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)
833: VALUES (p_mfg_org,'FRCST_PURP','RECEIPTS','RECEIPTS','RECEIPTS',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line 835: MERGE INTO ddr_r_lkup_mst lkup USING dual

831: WHEN NOT MATCHED THEN
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)
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');

Line 841: MERGE INTO ddr_r_lkup_mst lkup USING dual

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',

Line 849: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 855: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');

Line 861: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 868: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 875: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 882: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 889: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 896: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 903: MERGE INTO ddr_r_lkup_mst lkup USING dual

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
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)

Line 910: MERGE INTO ddr_r_lkup_mst lkup USING dual

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');
909:
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)

Line 917: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 924: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 931: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 938: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 945: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 952: MERGE INTO ddr_r_lkup_mst lkup USING dual

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)

Line 965: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 976: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 987: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 998: MERGE INTO ddr_ws_metadata ws USING dual

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
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)

Line 1009: MERGE INTO ddr_ws_metadata ws USING dual

1005: 'Y', 'Y', -1, SYSDATE, '-1',
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)

Line 1020: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1031: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1042: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1053: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1064: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1075: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1086: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1097: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1108: MERGE INTO ddr_ws_metadata ws USING dual

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
1109: ON (ws.hrchy_lvl_cd='INV_LOC_CD' AND hrchy_lvl_name='ORGANIZATION')
1110: WHEN NOT MATCHED THEN
1111: INSERT
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)

Line 1119: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1130: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1141: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1152: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1163: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1174: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1185: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1196: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1207: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1218: MERGE INTO ddr_ws_metadata ws USING dual

1214: 'Y', 'N', -1, SYSDATE, '-1',
1215: SYSDATE, '-1', v_version, 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)

Line 1229: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1240: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1251: MERGE INTO ddr_ws_metadata ws USING dual

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)

Line 1266: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1273: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1280: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1287: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1294: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1301: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1308: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1315: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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
1316: ON(lkup_typ_cd='ERR')
1317: WHEN NOT MATCHED THEN
1318: INSERT
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)

Line 1322: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1318: INSERT
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)
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)

Line 1329: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1336: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1343: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1350: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1357: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1364: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1371: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1378: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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:
1378: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1379: ON(lkup_typ_cd='ORG_TYP')
1380: WHEN NOT MATCHED THEN
1381: INSERT
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)

Line 1385: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1381: INSERT
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)

Line 1392: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1399: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1406: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1413: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1420: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1427: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1434: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1441: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1448: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1455: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1462: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1469: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1476: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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
1477: ON(lkup_typ_cd='MKT_AREA_TYP')
1478: WHEN NOT MATCHED THEN
1479: INSERT
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)

Line 1483: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1479: INSERT
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)
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)

Line 1490: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1498: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1505: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1512: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1519: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1526: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1533: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1540: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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');

Line 1546: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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');

Line 1553: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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)

Line 1560: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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');

Line 1566: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

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');