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 DDR_R_LKUP_MST

Line 45: --DELETE ddr_r_lkup_mst

41: END setup_mfg_org;
42:
43: PROCEDURE setup_lookup(p_mfg_org VARCHAR2) IS
44: BEGIN
45: --DELETE ddr_r_lkup_mst
46: --WHERE mfg_org_cd = p_mfg_org;
47:
48: MERGE INTO ddr_r_lkup_mst lkup USING dual
49: ON (lkup.lkup_typ_cd = 'BSNS_UNIT_TYP' AND lkup.lkup_cd = 'CATALOGUE')

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)