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.

[Home] [Help]

APPS.DDR_SETUP_UTIL dependencies on DDR_R_LKUP_TYP

Line 1265: --DELETE ddr_r_lkup_typ;

1261: END setup_ws_metadata;
1262:
1263: PROCEDURE setup_lookup_type IS
1264: BEGIN
1265: --DELETE ddr_r_lkup_typ;
1266: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1267: ON(lkup_typ_cd='ADDR_TYP')
1268: WHEN NOT MATCHED THEN
1269: INSERT

Line 1266: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1262:
1263: PROCEDURE setup_lookup_type IS
1264: BEGIN
1265: --DELETE ddr_r_lkup_typ;
1266: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1267: ON(lkup_typ_cd='ADDR_TYP')
1268: WHEN NOT MATCHED THEN
1269: INSERT
1270: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1273: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1269: INSERT
1270: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1271: VALUES ('ADDR_TYP','Address Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1272:
1273: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1274: ON(lkup_typ_cd='BRND')
1275: WHEN NOT MATCHED THEN
1276: INSERT
1277: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1280: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1276: INSERT
1277: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1278: VALUES ('BRND','Item Brand',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1279:
1280: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1281: ON(lkup_typ_cd='BSNS_UNIT_TYP')
1282: WHEN NOT MATCHED THEN
1283: INSERT
1284: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1287: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1283: INSERT
1284: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1285: VALUES ('BSNS_UNIT_TYP','Business Unit Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1286:
1287: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1288: ON(lkup_typ_cd='CHNL_TYP')
1289: WHEN NOT MATCHED THEN
1290: INSERT
1291: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1294: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1290: INSERT
1291: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1292: VALUES ('CHNL_TYP','Channel Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1293:
1294: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1295: ON(lkup_typ_cd='COATING')
1296: WHEN NOT MATCHED THEN
1297: INSERT
1298: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1301: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1297: INSERT
1298: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1299: VALUES ('COATING','Coating Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1300:
1301: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1302: ON(lkup_typ_cd='COLOR')
1303: WHEN NOT MATCHED THEN
1304: INSERT
1305: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1308: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1304: INSERT
1305: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1306: VALUES ('COLOR','Color',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1307:
1308: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1309: ON(lkup_typ_cd='DYE')
1310: WHEN NOT MATCHED THEN
1311: INSERT
1312: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1315: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1311: INSERT
1312: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1313: VALUES ('DYE','Dye',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1314:
1315: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1316: ON(lkup_typ_cd='ERR')
1317: WHEN NOT MATCHED THEN
1318: INSERT
1319: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1322: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1318: INSERT
1319: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1320: VALUES ('ERR','Error',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1321:
1322: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1323: ON(lkup_typ_cd='FABRIC')
1324: WHEN NOT MATCHED THEN
1325: INSERT
1326: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1329: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1325: INSERT
1326: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1327: VALUES ('FABRIC','Fabric',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1328:
1329: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1330: ON(lkup_typ_cd='FIBER')
1331: WHEN NOT MATCHED THEN
1332: INSERT
1333: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1336: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1332: INSERT
1333: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1334: VALUES ('FIBER','Fiber',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1335:
1336: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1337: ON(lkup_typ_cd='GIID_TYP')
1338: WHEN NOT MATCHED THEN
1339: INSERT
1340: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1343: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1339: INSERT
1340: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1341: VALUES ('GIID_TYP','GIID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1342:
1343: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1344: ON(lkup_typ_cd='GLID_TYP')
1345: WHEN NOT MATCHED THEN
1346: INSERT
1347: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1350: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1346: INSERT
1347: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1348: VALUES ('GLID_TYP','GLID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1349:
1350: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1351: ON(lkup_typ_cd='MEASURE')
1352: WHEN NOT MATCHED THEN
1353: INSERT
1354: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1357: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1353: INSERT
1354: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1355: VALUES ('MEASURE','Measure Name',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1356:
1357: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1358: ON(lkup_typ_cd='MEASURE_TYP')
1359: WHEN NOT MATCHED THEN
1360: INSERT
1361: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1364: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1360: INSERT
1361: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1362: VALUES ('MEASURE_TYP','Measure Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1363:
1364: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1365: ON(lkup_typ_cd='MFG_ITEM_LVL')
1366: WHEN NOT MATCHED THEN
1367: INSERT
1368: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1371: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1367: INSERT
1368: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1369: VALUES ('MFG_ITEM_LVL','Mfg Item Level Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1370:
1371: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1372: ON(lkup_typ_cd='ORG_LVL')
1373: WHEN NOT MATCHED THEN
1374: INSERT
1375: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1378: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1374: INSERT
1375: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1376: VALUES ('ORG_LVL','Organization Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1377:
1378: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1379: ON(lkup_typ_cd='ORG_TYP')
1380: WHEN NOT MATCHED THEN
1381: INSERT
1382: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1385: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1381: INSERT
1382: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1383: VALUES ('ORG_TYP','Organization Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1384:
1385: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1386: ON(lkup_typ_cd='RPLNSHMNT_TYP')
1387: WHEN NOT MATCHED THEN
1388: INSERT
1389: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1392: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1388: INSERT
1389: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1390: VALUES ('RPLNSHMNT_TYP','Replenishment Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1391:
1392: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1393: ON(lkup_typ_cd='RTL_ITEM_LVL')
1394: WHEN NOT MATCHED THEN
1395: INSERT
1396: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1399: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1395: INSERT
1396: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1397: VALUES ('RTL_ITEM_LVL','Retailer Item Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1398:
1399: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1400: ON(lkup_typ_cd='RTL_TYP')
1401: WHEN NOT MATCHED THEN
1402: INSERT
1403: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1406: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1402: INSERT
1403: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1404: VALUES ('RTL_TYP','Retail Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1405:
1406: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1407: ON(lkup_typ_cd='SKU_ITEM_STYLE')
1408: WHEN NOT MATCHED THEN
1409: INSERT
1410: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1413: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1409: INSERT
1410: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1411: VALUES ('SKU_ITEM_STYLE','SKU Item Style',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1412:
1413: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1414: ON(lkup_typ_cd='SKU_ITEM_TYP')
1415: WHEN NOT MATCHED THEN
1416: INSERT
1417: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1420: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1416: INSERT
1417: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1418: VALUES ('SKU_ITEM_TYP','SKU Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1419:
1420: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1421: ON(lkup_typ_cd='SLNG_LOC_TYP')
1422: WHEN NOT MATCHED THEN
1423: INSERT
1424: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1427: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1423: INSERT
1424: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1425: VALUES ('SLNG_LOC_TYP','Selling Location Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1426:
1427: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1428: ON(lkup_typ_cd='STCK_ITEM_TYP')
1429: WHEN NOT MATCHED THEN
1430: INSERT
1431: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1434: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1430: INSERT
1431: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1432: VALUES ('STCK_ITEM_TYP','Stock Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1433:
1434: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1435: ON(lkup_typ_cd='SYS_PARAM')
1436: WHEN NOT MATCHED THEN
1437: INSERT
1438: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1441: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1437: INSERT
1438: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1439: VALUES ('SYS_PARAM','System Parameter',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1440:
1441: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1442: ON(lkup_typ_cd='SZ_TYP')
1443: WHEN NOT MATCHED THEN
1444: INSERT
1445: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1448: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1444: INSERT
1445: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1446: VALUES ('SZ_TYP','Size Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1447:
1448: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1449: ON(lkup_typ_cd='TIME_LVL')
1450: WHEN NOT MATCHED THEN
1451: INSERT
1452: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1455: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1451: INSERT
1452: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1453: VALUES ('TIME_LVL','Time Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1454:
1455: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1456: ON(lkup_typ_cd='VRTY_TYP')
1457: WHEN NOT MATCHED THEN
1458: INSERT
1459: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1462: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1458: INSERT
1459: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1460: VALUES ('VRTY_TYP','Variety Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1461:
1462: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1463: ON(lkup_typ_cd='WEAVE')
1464: WHEN NOT MATCHED THEN
1465: INSERT
1466: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1469: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1465: INSERT
1466: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1467: VALUES ('WEAVE','Weave Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1468:
1469: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1470: ON(lkup_typ_cd='PRMTN_FLAG')
1471: WHEN NOT MATCHED THEN
1472: INSERT
1473: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1476: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1472: INSERT
1473: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1474: VALUES ('PRMTN_FLAG','Promotion Flag',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1475:
1476: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1477: ON(lkup_typ_cd='MKT_AREA_TYP')
1478: WHEN NOT MATCHED THEN
1479: INSERT
1480: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1483: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1479: INSERT
1480: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1481: VALUES ('MKT_AREA_TYP','Market Area Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1482:
1483: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1484: ON(lkup_typ_cd='ITM_TYP')
1485: WHEN NOT MATCHED THEN
1486: INSERT
1487: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1490: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1486: INSERT
1487: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1488: VALUES ('ITM_TYP','Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1489:
1490: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1491: ON(lkup_typ_cd='EXCPTN_TYP')
1492: WHEN NOT MATCHED THEN
1493: INSERT
1494: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1498: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1494: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1495: VALUES ('EXCPTN_TYP','Exception Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1496:
1497:
1498: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1499: ON(lkup_typ_cd='STR_ACV_RANGE')
1500: WHEN NOT MATCHED THEN
1501: INSERT
1502: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1505: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1501: INSERT
1502: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1503: VALUES ('STR_ACV_RANGE','Store ACV Range',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1504:
1505: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1506: ON(lkup_typ_cd='CMPNY_SIZE')
1507: WHEN NOT MATCHED THEN
1508: INSERT
1509: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1512: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1508: INSERT
1509: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1510: VALUES ('CMPNY_SIZE','Company Size',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1511:
1512: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1513: ON(lkup_typ_cd='SUB_CHNL_TYP')
1514: WHEN NOT MATCHED THEN
1515: INSERT
1516: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1519: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1515: INSERT
1516: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1517: VALUES ('SUB_CHNL_TYP','Sub Channel Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1518:
1519: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1520: ON(lkup_typ_cd='SRC_TYP')
1521: WHEN NOT MATCHED THEN
1522: INSERT
1523: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1526: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1522: INSERT
1523: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1524: VALUES ('SRC_TYP','Source Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1525:
1526: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1527: ON(lkup_typ_cd='MSR_SET')
1528: WHEN NOT MATCHED THEN
1529: INSERT
1530: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1533: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1529: INSERT
1530: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1531: VALUES ('MSR_SET','Measure Set',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1532:
1533: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1534: ON(lkup_typ_cd='STR_CLSTR_TYP')
1535: WHEN NOT MATCHED THEN
1536: INSERT
1537: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1540: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1536: INSERT
1537: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1538: VALUES ('STR_CLSTR_TYP','Store Cluster Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1539:
1540: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1541: ON(lkup_typ_cd='FRCST_PURP')
1542: WHEN NOT MATCHED THEN
1543: INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1544: VALUES('FRCST_PURP','Forecast Purpose',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line 1546: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1542: WHEN NOT MATCHED THEN
1543: INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1544: VALUES('FRCST_PURP','Forecast Purpose',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1545:
1546: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1547: ON(lkup_typ_cd='FRCST_TYP')
1548: WHEN NOT MATCHED THEN
1549: INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1550: VALUES('FRCST_TYP','Forecast Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line 1553: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1549: INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1550: VALUES('FRCST_TYP','Forecast Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1551:
1552:
1553: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1554: ON(lkup_typ_cd='SLS_TYP')
1555: WHEN NOT MATCHED THEN
1556: INSERT
1557: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

Line 1560: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1556: INSERT
1557: (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1558: VALUES ('SLS_TYP','Sales Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1559:
1560: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1561: ON(lkup_typ_cd='HCHY_TYPE')
1562: WHEN NOT MATCHED THEN
1563: INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1564: VALUES ('HCHY_TYPE','Additional Attributed Hierarchy Types',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');

Line 1566: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual

1562: WHEN NOT MATCHED THEN
1563: INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1564: VALUES ('HCHY_TYPE','Additional Attributed Hierarchy Types',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
1565:
1566: MERGE INTO ddr_r_lkup_typ lkuptyp USING dual
1567: ON(lkup_typ_cd='HCHY_LVL')
1568: WHEN NOT MATCHED THEN
1569: INSERT (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
1570: VALUES ('HCHY_LVL','Additional Attributed Hierarchy Levels',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');