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_WS_METADATA

Line 964: --DELETE ddr_ws_metadata;

960: END setup_lookup;
961:
962: PROCEDURE setup_ws_metadata IS
963: BEGIN
964: --DELETE ddr_ws_metadata;
965: MERGE INTO ddr_ws_metadata ws USING dual
966: ON (ws.hrchy_lvl_cd='MFG_CLASS_CD' AND hrchy_lvl_name='ITEM')
967: WHEN NOT MATCHED THEN
968: INSERT

Line 965: MERGE INTO ddr_ws_metadata ws USING dual

961:
962: PROCEDURE setup_ws_metadata IS
963: BEGIN
964: --DELETE ddr_ws_metadata;
965: MERGE INTO ddr_ws_metadata ws USING dual
966: ON (ws.hrchy_lvl_cd='MFG_CLASS_CD' AND hrchy_lvl_name='ITEM')
967: WHEN NOT MATCHED THEN
968: INSERT
969: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 976: MERGE INTO ddr_ws_metadata ws USING dual

972: 'Y', 'Y', -1, SYSDATE, '-1',
973: SYSDATE, '-1', v_version, SYSDATE, '-1',
974: '-1');
975:
976: MERGE INTO ddr_ws_metadata ws USING dual
977: ON (ws.hrchy_lvl_cd='MFG_SBC_CD' AND hrchy_lvl_name='ITEM')
978: WHEN NOT MATCHED THEN
979: INSERT
980: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 987: MERGE INTO ddr_ws_metadata ws USING dual

983: 'Y', 'Y', -1, SYSDATE, '-1',
984: SYSDATE, '-1', v_version, SYSDATE, '-1',
985: '-1');
986:
987: MERGE INTO ddr_ws_metadata ws USING dual
988: ON (ws.hrchy_lvl_cd='MFG_ITEM_NBR' AND hrchy_lvl_name='ITEM')
989: WHEN NOT MATCHED THEN
990: INSERT
991: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 998: MERGE INTO ddr_ws_metadata ws USING dual

994: 'Y', 'N', -1, SYSDATE, '-1',
995: SYSDATE, '-1', v_version, SYSDATE, '-1',
996: '-1');
997:
998: MERGE INTO ddr_ws_metadata ws USING dual
999: ON (ws.hrchy_lvl_cd='MFG_SKU_ITEM_NBR' AND hrchy_lvl_name='ITEM')
1000: WHEN NOT MATCHED THEN
1001: INSERT
1002: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1009: MERGE INTO ddr_ws_metadata ws USING dual

1005: 'Y', 'Y', -1, SYSDATE, '-1',
1006: SYSDATE, '-1', v_version, SYSDATE, '-1',
1007: '-1');
1008:
1009: MERGE INTO ddr_ws_metadata ws USING dual
1010: ON (ws.hrchy_lvl_cd='MFG_DIV_CD' AND hrchy_lvl_name='ITEM')
1011: WHEN NOT MATCHED THEN
1012: INSERT
1013: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1020: MERGE INTO ddr_ws_metadata ws USING dual

1016: 'Y', 'N', -1, SYSDATE, '-1',
1017: SYSDATE, '-1', v_version, SYSDATE, '-1',
1018: '-1');
1019:
1020: MERGE INTO ddr_ws_metadata ws USING dual
1021: ON (ws.hrchy_lvl_cd='MFG_GRP_CD' AND hrchy_lvl_name='ITEM')
1022: WHEN NOT MATCHED THEN
1023: INSERT
1024: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1031: MERGE INTO ddr_ws_metadata ws USING dual

1027: 'Y', 'N', -1, SYSDATE, '-1',
1028: SYSDATE, '-1', v_version, SYSDATE, '-1',
1029: '-1');
1030:
1031: MERGE INTO ddr_ws_metadata ws USING dual
1032: ON (ws.hrchy_lvl_cd='CLSTR_CD' AND hrchy_lvl_name='ORGANIZATION')
1033: WHEN NOT MATCHED THEN
1034: INSERT
1035: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1042: MERGE INTO ddr_ws_metadata ws USING dual

1038: 'Y', 'N', -1, SYSDATE, '-1',
1039: SYSDATE, '-1', v_version, SYSDATE, '-1',
1040: '-1');
1041:
1042: MERGE INTO ddr_ws_metadata ws USING dual
1043: ON (ws.hrchy_lvl_cd='ORG_CD' AND hrchy_lvl_name='ORGANIZATION')
1044: WHEN NOT MATCHED THEN
1045: INSERT
1046: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1053: MERGE INTO ddr_ws_metadata ws USING dual

1049: 'Y', 'N', -1, SYSDATE, '-1',
1050: SYSDATE, '-1', v_version, SYSDATE, '-1',
1051: '-1');
1052:
1053: MERGE INTO ddr_ws_metadata ws USING dual
1054: ON (ws.hrchy_lvl_cd='CHAIN_CD' AND hrchy_lvl_name='ORGANIZATION')
1055: WHEN NOT MATCHED THEN
1056: INSERT
1057: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1064: MERGE INTO ddr_ws_metadata ws USING dual

1060: 'Y', 'N', -1, SYSDATE, '-1',
1061: SYSDATE, '-1', v_version, SYSDATE, '-1',
1062: '-1');
1063:
1064: MERGE INTO ddr_ws_metadata ws USING dual
1065: ON (ws.hrchy_lvl_cd='AREA_CD' AND hrchy_lvl_name='ORGANIZATION')
1066: WHEN NOT MATCHED THEN
1067: INSERT
1068: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1075: MERGE INTO ddr_ws_metadata ws USING dual

1071: 'N', 'N', -1, SYSDATE, '-1',
1072: SYSDATE, '-1', v_version, SYSDATE, '-1',
1073: '-1');
1074:
1075: MERGE INTO ddr_ws_metadata ws USING dual
1076: ON (ws.hrchy_lvl_cd='RGN_CD' AND hrchy_lvl_name='ORGANIZATION')
1077: WHEN NOT MATCHED THEN
1078: INSERT
1079: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1086: MERGE INTO ddr_ws_metadata ws USING dual

1082: 'N', 'N', -1, SYSDATE, '-1',
1083: SYSDATE, '-1', v_version, SYSDATE, '-1',
1084: '-1');
1085:
1086: MERGE INTO ddr_ws_metadata ws USING dual
1087: ON (ws.hrchy_lvl_cd='DSTRCT_CD' AND hrchy_lvl_name='ORGANIZATION')
1088: WHEN NOT MATCHED THEN
1089: INSERT
1090: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1097: MERGE INTO ddr_ws_metadata ws USING dual

1093: 'N', 'N', -1, SYSDATE, '-1',
1094: SYSDATE, '-1', v_version, SYSDATE, '-1',
1095: '-1');
1096:
1097: MERGE INTO ddr_ws_metadata ws USING dual
1098: ON (ws.hrchy_lvl_cd='BSNS_UNIT_CD' AND hrchy_lvl_name='ORGANIZATION')
1099: WHEN NOT MATCHED THEN
1100: INSERT
1101: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1108: MERGE INTO ddr_ws_metadata ws USING dual

1104: 'N', 'N', -1, SYSDATE, '-1',
1105: SYSDATE, '-1', v_version, SYSDATE, '-1',
1106: '-1');
1107:
1108: MERGE INTO ddr_ws_metadata ws USING dual
1109: ON (ws.hrchy_lvl_cd='INV_LOC_CD' AND hrchy_lvl_name='ORGANIZATION')
1110: WHEN NOT MATCHED THEN
1111: INSERT
1112: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1119: MERGE INTO ddr_ws_metadata ws USING dual

1115: 'Y', 'N', -1, SYSDATE, '-1',
1116: SYSDATE, '-1', v_version, SYSDATE, '-1',
1117: '-1');
1118:
1119: MERGE INTO ddr_ws_metadata ws USING dual
1120: ON (ws.hrchy_lvl_cd='CNTRY_CD' AND hrchy_lvl_name='LOCATION')
1121: WHEN NOT MATCHED THEN
1122: INSERT
1123: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1130: MERGE INTO ddr_ws_metadata ws USING dual

1126: 'N', 'N', -1, SYSDATE, '-1',
1127: SYSDATE, '-1', v_version, SYSDATE, '-1',
1128: '-1');
1129:
1130: MERGE INTO ddr_ws_metadata ws USING dual
1131: ON (ws.hrchy_lvl_cd='STATE_CD' AND hrchy_lvl_name='LOCATION')
1132: WHEN NOT MATCHED THEN
1133: INSERT
1134: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1141: MERGE INTO ddr_ws_metadata ws USING dual

1137: 'N', 'N', -1, SYSDATE, '-1',
1138: SYSDATE, '-1', v_version, SYSDATE, '-1',
1139: '-1');
1140:
1141: MERGE INTO ddr_ws_metadata ws USING dual
1142: ON (ws.hrchy_lvl_cd='CITY_CD' AND hrchy_lvl_name='LOCATION')
1143: WHEN NOT MATCHED THEN
1144: INSERT
1145: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1152: MERGE INTO ddr_ws_metadata ws USING dual

1148: 'N', 'N', -1, SYSDATE, '-1',
1149: SYSDATE, '-1', v_version, SYSDATE, '-1',
1150: '-1');
1151:
1152: MERGE INTO ddr_ws_metadata ws USING dual
1153: ON (ws.hrchy_lvl_cd='CLNDR_YR_CD' AND hrchy_lvl_name='GREGORIAN TIME')
1154: WHEN NOT MATCHED THEN
1155: INSERT
1156: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1163: MERGE INTO ddr_ws_metadata ws USING dual

1159: 'Y', 'N', -1, SYSDATE, '-1',
1160: SYSDATE, '-1', v_version, SYSDATE, '-1',
1161: '-1');
1162:
1163: MERGE INTO ddr_ws_metadata ws USING dual
1164: ON (ws.hrchy_lvl_cd='CLNDR_QTR_CD' AND hrchy_lvl_name='GREGORIAN TIME')
1165: WHEN NOT MATCHED THEN
1166: INSERT
1167: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1174: MERGE INTO ddr_ws_metadata ws USING dual

1170: 'Y', 'N', -1, SYSDATE, '-1',
1171: SYSDATE, '-1', v_version, SYSDATE, '-1',
1172: '-1');
1173:
1174: MERGE INTO ddr_ws_metadata ws USING dual
1175: ON (ws.hrchy_lvl_cd='CLNDR_MNTH_CD' AND hrchy_lvl_name='GREGORIAN TIME')
1176: WHEN NOT MATCHED THEN
1177: INSERT
1178: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1185: MERGE INTO ddr_ws_metadata ws USING dual

1181: 'Y', 'N', -1, SYSDATE, '-1',
1182: SYSDATE, '-1', v_version, SYSDATE, '-1',
1183: '-1');
1184:
1185: MERGE INTO ddr_ws_metadata ws USING dual
1186: ON (ws.hrchy_lvl_cd='CLNDR_WK_CD' AND hrchy_lvl_name='GREGORIAN TIME')
1187: WHEN NOT MATCHED THEN
1188: INSERT
1189: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1196: MERGE INTO ddr_ws_metadata ws USING dual

1192: 'Y', 'N', -1, SYSDATE, '-1',
1193: SYSDATE, '-1', v_version, SYSDATE, '-1',
1194: '-1');
1195:
1196: MERGE INTO ddr_ws_metadata ws USING dual
1197: ON (ws.hrchy_lvl_cd='CLNDR_DAY_CD' AND hrchy_lvl_name='GREGORIAN TIME')
1198: WHEN NOT MATCHED THEN
1199: INSERT
1200: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1207: MERGE INTO ddr_ws_metadata ws USING dual

1203: 'Y', 'Y', -1, SYSDATE, '-1',
1204: SYSDATE, '-1', v_version, SYSDATE, '-1',
1205: '-1');
1206:
1207: MERGE INTO ddr_ws_metadata ws USING dual
1208: ON (ws.hrchy_lvl_cd='BSNS_YR_CD' AND hrchy_lvl_name='BUSINESS TIME')
1209: WHEN NOT MATCHED THEN
1210: INSERT
1211: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1218: MERGE INTO ddr_ws_metadata ws USING dual

1214: 'Y', 'N', -1, SYSDATE, '-1',
1215: SYSDATE, '-1', v_version, SYSDATE, '-1',
1216: '-1');
1217:
1218: MERGE INTO ddr_ws_metadata ws USING dual
1219: ON (ws.hrchy_lvl_cd='BSNS_QTR_CD' AND hrchy_lvl_name='BUSINESS TIME')
1220: WHEN NOT MATCHED THEN
1221: INSERT
1222: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1229: MERGE INTO ddr_ws_metadata ws USING dual

1225: 'Y', 'N', -1, SYSDATE, '-1',
1226: SYSDATE, '-1', v_version, SYSDATE, '-1',
1227: '-1');
1228:
1229: MERGE INTO ddr_ws_metadata ws USING dual
1230: ON (ws.hrchy_lvl_cd='BSNS_MNTH_CD' AND hrchy_lvl_name='BUSINESS TIME')
1231: WHEN NOT MATCHED THEN
1232: INSERT
1233: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1240: MERGE INTO ddr_ws_metadata ws USING dual

1236: 'Y', 'N', -1, SYSDATE, '-1',
1237: SYSDATE, '-1', v_version, SYSDATE, '-1',
1238: '-1');
1239:
1240: MERGE INTO ddr_ws_metadata ws USING dual
1241: ON (ws.hrchy_lvl_cd='BSNS_DAY_CD' AND hrchy_lvl_name='BUSINESS TIME')
1242: WHEN NOT MATCHED THEN
1243: INSERT
1244: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)

Line 1251: MERGE INTO ddr_ws_metadata ws USING dual

1247: 'Y', 'N', -1, SYSDATE, '-1',
1248: SYSDATE, '-1', v_version, SYSDATE, '-1',
1249: '-1');
1250:
1251: MERGE INTO ddr_ws_metadata ws USING dual
1252: ON (ws.hrchy_lvl_cd='BSNS_WK_CD' AND hrchy_lvl_name='BUSINESS TIME')
1253: WHEN NOT MATCHED THEN
1254: INSERT
1255: (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)