DBA Data[Home] [Help]

APPS.CZ_MIGRATE dependencies on CZ_XFR_TABLES

Line 216: DELETE FROM cz_xfr_tables WHERE UPPER(xfr_group) IN

212: --Populate the control table.
213:
214: BEGIN
215:
216: DELETE FROM cz_xfr_tables WHERE UPPER(xfr_group) IN
217: ('OVERRIDE', 'SLOWREFRESH', 'MIGRATE', 'REFRESH', 'FORCESLOW', 'TRIGGERS', 'SEQUENCES');
218:
219: INSERT INTO cz_xfr_tables (order_seq, xfr_group, disabled, dst_table, pk_useexpansion)
220: SELECT ROWNUM, 'OVERRIDE', '0', table_name, DECODE(logging, 'YES', 'Y', 'NO', 'N', 'N')

Line 219: INSERT INTO cz_xfr_tables (order_seq, xfr_group, disabled, dst_table, pk_useexpansion)

215:
216: DELETE FROM cz_xfr_tables WHERE UPPER(xfr_group) IN
217: ('OVERRIDE', 'SLOWREFRESH', 'MIGRATE', 'REFRESH', 'FORCESLOW', 'TRIGGERS', 'SEQUENCES');
218:
219: INSERT INTO cz_xfr_tables (order_seq, xfr_group, disabled, dst_table, pk_useexpansion)
220: SELECT ROWNUM, 'OVERRIDE', '0', table_name, DECODE(logging, 'YES', 'Y', 'NO', 'N', 'N')
221: FROM all_tables
222: WHERE owner = 'CZ';
223:

Line 224: INSERT INTO cz_xfr_tables (order_seq, xfr_group, disabled, dst_table)

220: SELECT ROWNUM, 'OVERRIDE', '0', table_name, DECODE(logging, 'YES', 'Y', 'NO', 'N', 'N')
221: FROM all_tables
222: WHERE owner = 'CZ';
223:
224: INSERT INTO cz_xfr_tables (order_seq, xfr_group, disabled, dst_table)
225: SELECT ROWNUM, 'TRIGGERS', '0', trigger_name
226: FROM user_triggers
227: WHERE status = 'ENABLED'
228: AND trigger_name LIKE 'CZ/_%' ESCAPE '/';

Line 242: FOR c_tables IN (SELECT dst_table FROM cz_xfr_tables

238: END;
239:
240: errorFlag := 0;
241:
242: FOR c_tables IN (SELECT dst_table FROM cz_xfr_tables
243: WHERE xfr_group in ('OVERRIDE', 'SLOWREFRESH', 'MIGRATE', 'REFRESH', 'FORCESLOW')
244: AND disabled = '0') LOOP
245:
246: xError := compare_columns(c_tables.dst_table);

Line 441: FOR c_table IN (SELECT NULL FROM cz_xfr_tables

437:
438: --CZ_SERVERS: we need to make sure that the current server entry would not conflict with a server entry in
439: --the source table. Do this only if CZ_SERVERS is on the processing list and only for 'MIGRATE' operation.
440:
441: FOR c_table IN (SELECT NULL FROM cz_xfr_tables
442: WHERE UPPER(dst_table) = 'CZ_SERVERS'
443: AND UPPER(xfr_group) = 'MIGRATE'
444: AND disabled = '0'
445: AND ROWNUM = 1) LOOP

Line 469: FOR c_tables IN (SELECT dst_table FROM cz_xfr_tables

465: END LOOP;
466:
467: --End of the table-specific data preparation section------------------------------------------------------
468:
469: FOR c_tables IN (SELECT dst_table FROM cz_xfr_tables
470: WHERE xfr_group IN ('OVERRIDE', 'SLOWREFRESH', 'MIGRATE', 'REFRESH', 'FORCESLOW')
471: AND disabled = '0' AND pk_useexpansion = 'Y') LOOP
472:
473: EXECUTE IMMEDIATE 'ALTER TABLE ' || CONFIGURATOR_SCHEMA || '.' || c_tables.dst_table || ' NOLOGGING';

Line 478: FOR c_tables IN (SELECT dst_table FROM cz_xfr_tables

474: END LOOP;
475:
476: xError := copy_all_tables(CommitSize, StopOnSkippable, AllowRefresh, ForceSlowMode, ForceProcess);
477:
478: FOR c_tables IN (SELECT dst_table FROM cz_xfr_tables
479: WHERE xfr_group IN ('OVERRIDE', 'SLOWREFRESH', 'MIGRATE', 'REFRESH', 'FORCESLOW')
480: AND disabled = '0' AND pk_useexpansion = 'Y') LOOP
481:
482: EXECUTE IMMEDIATE 'ALTER TABLE ' || CONFIGURATOR_SCHEMA || '.' || c_tables.dst_table || ' LOGGING';

Line 1034: for c_tables in (select dst_table from cz_xfr_tables where xfr_group='OVERRIDE' and disabled='0') loop

1030: inForceProcess in number)
1031: return integer is
1032: xError integer;
1033: begin
1034: for c_tables in (select dst_table from cz_xfr_tables where xfr_group='OVERRIDE' and disabled='0') loop
1035: xError := copy_table_override(c_tables.dst_table, inStopOnSkippable);
1036: if(xError = FATAL_ERROR or (xError = SKIPPABLE_ERROR and inStopOnSkippable = 1))then
1037: return xError;
1038: end if;

Line 1040: for c_tables in (select dst_table from cz_xfr_tables where xfr_group='MIGRATE' and disabled='0') loop

1036: if(xError = FATAL_ERROR or (xError = SKIPPABLE_ERROR and inStopOnSkippable = 1))then
1037: return xError;
1038: end if;
1039: end loop;
1040: for c_tables in (select dst_table from cz_xfr_tables where xfr_group='MIGRATE' and disabled='0') loop
1041: xError := copy_table(c_tables.dst_table, inCommitSize, inStopOnSkippable, inRefreshable, inForceSlowMode, inForceProcess);
1042: if(xError = FATAL_ERROR or (xError = SKIPPABLE_ERROR and inStopOnSkippable = 1))then
1043: return xError;
1044: end if;

Line 1046: for c_tables in (select dst_table from cz_xfr_tables where xfr_group='REFRESH' and disabled='0') loop

1042: if(xError = FATAL_ERROR or (xError = SKIPPABLE_ERROR and inStopOnSkippable = 1))then
1043: return xError;
1044: end if;
1045: end loop;
1046: for c_tables in (select dst_table from cz_xfr_tables where xfr_group='REFRESH' and disabled='0') loop
1047: xError := copy_table(c_tables.dst_table, inCommitSize, inStopOnSkippable, 1, inForceSlowMode, 1);
1048: if(xError = FATAL_ERROR or (xError = SKIPPABLE_ERROR and inStopOnSkippable = 1))then
1049: return xError;
1050: end if;

Line 1052: for c_tables in (select dst_table from cz_xfr_tables where xfr_group='FORCESLOW' and disabled='0') loop

1048: if(xError = FATAL_ERROR or (xError = SKIPPABLE_ERROR and inStopOnSkippable = 1))then
1049: return xError;
1050: end if;
1051: end loop;
1052: for c_tables in (select dst_table from cz_xfr_tables where xfr_group='FORCESLOW' and disabled='0') loop
1053: xError := copy_table(c_tables.dst_table, inCommitSize, inStopOnSkippable, inRefreshable, 1, inForceProcess);
1054: if(xError = FATAL_ERROR or (xError = SKIPPABLE_ERROR and inStopOnSkippable = 1))then
1055: return xError;
1056: end if;

Line 1058: for c_tables in (select dst_table from cz_xfr_tables where xfr_group='SLOWREFRESH' and disabled='0') loop

1054: if(xError = FATAL_ERROR or (xError = SKIPPABLE_ERROR and inStopOnSkippable = 1))then
1055: return xError;
1056: end if;
1057: end loop;
1058: for c_tables in (select dst_table from cz_xfr_tables where xfr_group='SLOWREFRESH' and disabled='0') loop
1059: xError := copy_table(c_tables.dst_table, inCommitSize, inStopOnSkippable, 1, 1, 1);
1060: if(xError = FATAL_ERROR or (xError = SKIPPABLE_ERROR and inStopOnSkippable = 1))then
1061: return xError;
1062: end if;

Line 1336: for c_triggers in (select dst_table from cz_xfr_tables where xfr_group='TRIGGERS' and disabled='0') loop

1332: return integer is
1333: cdyn integer;
1334: rdyn integer;
1335: begin
1336: for c_triggers in (select dst_table from cz_xfr_tables where xfr_group='TRIGGERS' and disabled='0') loop
1337: begin
1338: cdyn := dbms_sql.open_cursor;
1339: dbms_sql.parse(cdyn,'alter trigger '||c_triggers.dst_table||' disable',dbms_sql.native);
1340: rdyn := dbms_sql.execute(cdyn);

Line 1358: for c_triggers in (select dst_table from cz_xfr_tables where xfr_group='TRIGGERS' and disabled='0') loop

1354: return integer is
1355: cdyn integer;
1356: rdyn integer;
1357: begin
1358: for c_triggers in (select dst_table from cz_xfr_tables where xfr_group='TRIGGERS' and disabled='0') loop
1359: begin
1360: cdyn := dbms_sql.open_cursor;
1361: dbms_sql.parse(cdyn,'alter trigger '||c_triggers.dst_table||' enable',dbms_sql.native);
1362: rdyn := dbms_sql.execute(cdyn);

Line 1442: --CZ_XFR_TABLES:

1438: RETURN INTEGER IS
1439: xError INTEGER;
1440: BEGIN
1441:
1442: --CZ_XFR_TABLES:
1443: -- SRC_TABLE - sequence name;
1444: -- DST_TABLE - corresponding table name;
1445: -- DST_SUBSCHEMA - corresponding table column name (the sequence is used to generate values for this column);
1446: -- FILTERSYNTAX - character representation of the sequence increment.

Line 1448: FOR c_seq IN (SELECT src_table, dst_table, dst_subschema, filtersyntax FROM cz_xfr_tables

1444: -- DST_TABLE - corresponding table name;
1445: -- DST_SUBSCHEMA - corresponding table column name (the sequence is used to generate values for this column);
1446: -- FILTERSYNTAX - character representation of the sequence increment.
1447:
1448: FOR c_seq IN (SELECT src_table, dst_table, dst_subschema, filtersyntax FROM cz_xfr_tables
1449: WHERE xfr_group = 'SEQUENCES' AND disabled = '0') LOOP
1450:
1451: xError := adjust_sequence(c_seq.src_table, c_seq.dst_table, c_seq.dst_subschema, TO_NUMBER(c_seq.filtersyntax));
1452: IF(xError = FATAL_ERROR OR (xError = SKIPPABLE_ERROR AND inStopOnSkippable = 1))THEN RETURN xError; END IF;

Line 1496: UPDATE cz_xfr_tables SET disabled = '1'

1492: END;
1493:
1494: --A. Tsyaston 14-Oct-2004 BUG 3937232 - List revised.
1495:
1496: UPDATE cz_xfr_tables SET disabled = '1'
1497: WHERE UPPER(xfr_group) = 'OVERRIDE'
1498: AND UPPER(dst_table) IN
1499: ('CZ_XFR_TABLES', 'CZ_ATP_REQUESTS', 'CZ_DB_LOGS', 'CZ_EXP_TMP_LINES', 'CZ_TERMINATE_MSGS',
1500: 'CZ_PRICING_STRUCTURES', 'CZ_ITEM_PARENTS', 'CZ_INTL_TEXTS', 'CZ_LOOKUP_VALUES_TL',

Line 1499: ('CZ_XFR_TABLES', 'CZ_ATP_REQUESTS', 'CZ_DB_LOGS', 'CZ_EXP_TMP_LINES', 'CZ_TERMINATE_MSGS',

1495:
1496: UPDATE cz_xfr_tables SET disabled = '1'
1497: WHERE UPPER(xfr_group) = 'OVERRIDE'
1498: AND UPPER(dst_table) IN
1499: ('CZ_XFR_TABLES', 'CZ_ATP_REQUESTS', 'CZ_DB_LOGS', 'CZ_EXP_TMP_LINES', 'CZ_TERMINATE_MSGS',
1500: 'CZ_PRICING_STRUCTURES', 'CZ_ITEM_PARENTS', 'CZ_INTL_TEXTS', 'CZ_LOOKUP_VALUES_TL',
1501: 'CZ_LOOKUP_VALUES', 'CZ_TYPE_RELATIONSHIPS');
1502:
1503: UPDATE cz_xfr_tables SET disabled = '1'

Line 1503: UPDATE cz_xfr_tables SET disabled = '1'

1499: ('CZ_XFR_TABLES', 'CZ_ATP_REQUESTS', 'CZ_DB_LOGS', 'CZ_EXP_TMP_LINES', 'CZ_TERMINATE_MSGS',
1500: 'CZ_PRICING_STRUCTURES', 'CZ_ITEM_PARENTS', 'CZ_INTL_TEXTS', 'CZ_LOOKUP_VALUES_TL',
1501: 'CZ_LOOKUP_VALUES', 'CZ_TYPE_RELATIONSHIPS');
1502:
1503: UPDATE cz_xfr_tables SET disabled = '1'
1504: WHERE UPPER(xfr_group) = 'OVERRIDE'
1505: AND UPPER(dst_table) LIKE 'CZ/_IMP/_%' ESCAPE '/';
1506:
1507: UPDATE cz_xfr_tables SET disabled = '1'

Line 1507: UPDATE cz_xfr_tables SET disabled = '1'

1503: UPDATE cz_xfr_tables SET disabled = '1'
1504: WHERE UPPER(xfr_group) = 'OVERRIDE'
1505: AND UPPER(dst_table) LIKE 'CZ/_IMP/_%' ESCAPE '/';
1506:
1507: UPDATE cz_xfr_tables SET disabled = '1'
1508: WHERE UPPER(xfr_group) = 'OVERRIDE'
1509: AND UPPER(dst_table) NOT LIKE 'CZ/_%' ESCAPE '/';
1510:
1511: --Bug #2458532 - disable migrating of the configuration data. Just disable copying the table data,

Line 1516: UPDATE cz_xfr_tables SET disabled = '1'

1512: --do not worry about sequences and triggers.
1513:
1514: IF(migrateConfigData = 0)THEN
1515:
1516: UPDATE cz_xfr_tables SET disabled = '1'
1517: WHERE UPPER(xfr_group) = 'OVERRIDE'
1518: AND UPPER(dst_table) IN
1519: ('CZ_CONFIG_ATTRIBUTES', 'CZ_CONFIG_EXT_ATTRIBUTES', 'CZ_CONFIG_HDRS', 'CZ_CONFIG_INPUTS',
1520: 'CZ_CONFIG_ITEMS', 'CZ_CONFIG_MESSAGES', 'CZ_CONFIG_USAGES');

Line 1525: UPDATE cz_xfr_tables SET xfr_group = 'SLOWREFRESH'

1521: END IF;
1522:
1523: --CZ_XFR_FIELDS moved to the 'SLOWREFRESH' group, bug #3620255 (original #3283062).
1524:
1525: UPDATE cz_xfr_tables SET xfr_group = 'SLOWREFRESH'
1526: WHERE UPPER(xfr_group) = 'OVERRIDE'
1527: AND UPPER(dst_table) IN ('CZ_DB_SETTINGS', 'CZ_XFR_FIELDS');
1528:
1529: UPDATE cz_xfr_tables SET xfr_group = 'MIGRATE'

Line 1529: UPDATE cz_xfr_tables SET xfr_group = 'MIGRATE'

1525: UPDATE cz_xfr_tables SET xfr_group = 'SLOWREFRESH'
1526: WHERE UPPER(xfr_group) = 'OVERRIDE'
1527: AND UPPER(dst_table) IN ('CZ_DB_SETTINGS', 'CZ_XFR_FIELDS');
1528:
1529: UPDATE cz_xfr_tables SET xfr_group = 'MIGRATE'
1530: WHERE UPPER(xfr_group) = 'OVERRIDE'
1531: AND UPPER(dst_table) = 'CZ_SERVERS';
1532:
1533: UPDATE cz_xfr_tables SET disabled = '1'

Line 1533: UPDATE cz_xfr_tables SET disabled = '1'

1529: UPDATE cz_xfr_tables SET xfr_group = 'MIGRATE'
1530: WHERE UPPER(xfr_group) = 'OVERRIDE'
1531: AND UPPER(dst_table) = 'CZ_SERVERS';
1532:
1533: UPDATE cz_xfr_tables SET disabled = '1'
1534: WHERE UPPER(xfr_group) = 'TRIGGERS'
1535: AND UPPER(dst_table) NOT LIKE 'CZ/_%' ESCAPE '/';
1536:
1537: INSERT INTO cz_xfr_tables

Line 1537: INSERT INTO cz_xfr_tables

1533: UPDATE cz_xfr_tables SET disabled = '1'
1534: WHERE UPPER(xfr_group) = 'TRIGGERS'
1535: AND UPPER(dst_table) NOT LIKE 'CZ/_%' ESCAPE '/';
1536:
1537: INSERT INTO cz_xfr_tables
1538: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1539: VALUES
1540: (1, 'SEQUENCES', '0', 'CZ_ADDRESSES_S', 'CZ_ADDRESSES', 'ADDRESS_ID', '20');
1541:

Line 1542: INSERT INTO cz_xfr_tables

1538: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1539: VALUES
1540: (1, 'SEQUENCES', '0', 'CZ_ADDRESSES_S', 'CZ_ADDRESSES', 'ADDRESS_ID', '20');
1541:
1542: INSERT INTO cz_xfr_tables
1543: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1544: VALUES
1545: (2, 'SEQUENCES', '0', 'CZ_ADDRESS_USES_S', 'CZ_ADDRESS_USES', 'ADDRESS_USE_ID', '20');
1546:

Line 1547: INSERT INTO cz_xfr_tables

1543: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1544: VALUES
1545: (2, 'SEQUENCES', '0', 'CZ_ADDRESS_USES_S', 'CZ_ADDRESS_USES', 'ADDRESS_USE_ID', '20');
1546:
1547: INSERT INTO cz_xfr_tables
1548: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1549: VALUES
1550: (4, 'SEQUENCES', '0', 'CZ_COMBO_FEATURES_S', 'CZ_COMBO_FEATURES', 'FEATURE_ID', '20');
1551:

Line 1552: INSERT INTO cz_xfr_tables

1548: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1549: VALUES
1550: (4, 'SEQUENCES', '0', 'CZ_COMBO_FEATURES_S', 'CZ_COMBO_FEATURES', 'FEATURE_ID', '20');
1551:
1552: INSERT INTO cz_xfr_tables
1553: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1554: VALUES
1555: (5, 'SEQUENCES', '0', 'CZ_CONFIG_HDRS_S', 'CZ_CONFIG_HDRS', 'CONFIG_HDR_ID', '20');
1556:

Line 1557: INSERT INTO cz_xfr_tables

1553: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1554: VALUES
1555: (5, 'SEQUENCES', '0', 'CZ_CONFIG_HDRS_S', 'CZ_CONFIG_HDRS', 'CONFIG_HDR_ID', '20');
1556:
1557: INSERT INTO cz_xfr_tables
1558: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1559: VALUES
1560: (6, 'SEQUENCES', '0', 'CZ_CONFIG_INPUTS_S', 'CZ_CONFIG_INPUTS', 'CONFIG_INPUT_ID', '20');
1561:

Line 1562: INSERT INTO cz_xfr_tables

1558: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1559: VALUES
1560: (6, 'SEQUENCES', '0', 'CZ_CONFIG_INPUTS_S', 'CZ_CONFIG_INPUTS', 'CONFIG_INPUT_ID', '20');
1561:
1562: INSERT INTO cz_xfr_tables
1563: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1564: VALUES
1565: (7, 'SEQUENCES', '0', 'CZ_CONFIG_ITEMS_S', 'CZ_CONFIG_ITEMS', 'CONFIG_ITEM_ID', '20');
1566:

Line 1567: INSERT INTO cz_xfr_tables

1563: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1564: VALUES
1565: (7, 'SEQUENCES', '0', 'CZ_CONFIG_ITEMS_S', 'CZ_CONFIG_ITEMS', 'CONFIG_ITEM_ID', '20');
1566:
1567: INSERT INTO cz_xfr_tables
1568: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1569: VALUES
1570: (8, 'SEQUENCES', '0', 'CZ_CONFIG_MESSAGES_S', 'CZ_CONFIG_MESSAGES', 'MESSAGE_SEQ', '20');
1571:

Line 1572: INSERT INTO cz_xfr_tables

1568: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1569: VALUES
1570: (8, 'SEQUENCES', '0', 'CZ_CONFIG_MESSAGES_S', 'CZ_CONFIG_MESSAGES', 'MESSAGE_SEQ', '20');
1571:
1572: INSERT INTO cz_xfr_tables
1573: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1574: VALUES
1575: (9, 'SEQUENCES', '0', 'CZ_CONTACTS_S', 'CZ_CONTACTS', 'CONTACT_ID', '20');
1576:

Line 1577: INSERT INTO cz_xfr_tables

1573: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1574: VALUES
1575: (9, 'SEQUENCES', '0', 'CZ_CONTACTS_S', 'CZ_CONTACTS', 'CONTACT_ID', '20');
1576:
1577: INSERT INTO cz_xfr_tables
1578: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1579: VALUES
1580: (10, 'SEQUENCES', '0', 'CZ_CUSTOMERS_S', 'CZ_CUSTOMERS', 'CUSTOMER_ID', '20');
1581:

Line 1582: INSERT INTO cz_xfr_tables

1578: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1579: VALUES
1580: (10, 'SEQUENCES', '0', 'CZ_CUSTOMERS_S', 'CZ_CUSTOMERS', 'CUSTOMER_ID', '20');
1581:
1582: INSERT INTO cz_xfr_tables
1583: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1584: VALUES
1585: (13, 'SEQUENCES', '0', 'CZ_DEVL_PROJECTS_S', 'CZ_DEVL_PROJECTS', 'DEVL_PROJECT_ID', '20');
1586:

Line 1587: INSERT INTO cz_xfr_tables

1583: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1584: VALUES
1585: (13, 'SEQUENCES', '0', 'CZ_DEVL_PROJECTS_S', 'CZ_DEVL_PROJECTS', 'DEVL_PROJECT_ID', '20');
1586:
1587: INSERT INTO cz_xfr_tables
1588: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1589: VALUES
1590: (14, 'SEQUENCES', '0', 'CZ_DRILL_DOWN_ITEMS_S', 'CZ_DRILL_DOWN_ITEMS', 'DD_SEQ_NBR', '20');
1591:

Line 1592: INSERT INTO cz_xfr_tables

1588: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1589: VALUES
1590: (14, 'SEQUENCES', '0', 'CZ_DRILL_DOWN_ITEMS_S', 'CZ_DRILL_DOWN_ITEMS', 'DD_SEQ_NBR', '20');
1591:
1592: INSERT INTO cz_xfr_tables
1593: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1594: VALUES
1595: (15, 'SEQUENCES', '0', 'CZ_EFFECTIVITY_SETS_S', 'CZ_EFFECTIVITY_SETS', 'EFFECTIVITY_SET_ID', '20');
1596:

Line 1597: INSERT INTO cz_xfr_tables

1593: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1594: VALUES
1595: (15, 'SEQUENCES', '0', 'CZ_EFFECTIVITY_SETS_S', 'CZ_EFFECTIVITY_SETS', 'EFFECTIVITY_SET_ID', '20');
1596:
1597: INSERT INTO cz_xfr_tables
1598: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1599: VALUES
1600: (16, 'SEQUENCES', '0', 'CZ_END_USERS_S', 'CZ_END_USERS', 'END_USER_ID', '20');
1601:

Line 1602: INSERT INTO cz_xfr_tables

1598: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1599: VALUES
1600: (16, 'SEQUENCES', '0', 'CZ_END_USERS_S', 'CZ_END_USERS', 'END_USER_ID', '20');
1601:
1602: INSERT INTO cz_xfr_tables
1603: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1604: VALUES
1605: (18, 'SEQUENCES', '0', 'CZ_EXPRESSIONS_S', 'CZ_EXPRESSIONS', 'EXPRESS_ID', '20');
1606:

Line 1607: INSERT INTO cz_xfr_tables

1603: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1604: VALUES
1605: (18, 'SEQUENCES', '0', 'CZ_EXPRESSIONS_S', 'CZ_EXPRESSIONS', 'EXPRESS_ID', '20');
1606:
1607: INSERT INTO cz_xfr_tables
1608: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1609: VALUES
1610: (19, 'SEQUENCES', '0', 'CZ_EXPRESSION_NODES_S', 'CZ_EXPRESSION_NODES', 'EXPR_NODE_ID', '20');
1611:

Line 1612: INSERT INTO cz_xfr_tables

1608: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1609: VALUES
1610: (19, 'SEQUENCES', '0', 'CZ_EXPRESSION_NODES_S', 'CZ_EXPRESSION_NODES', 'EXPR_NODE_ID', '20');
1611:
1612: INSERT INTO cz_xfr_tables
1613: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1614: VALUES
1615: (20, 'SEQUENCES', '0', 'CZ_FILTER_SETS_S', 'CZ_FILTER_SETS', 'FILTER_SET_ID', '20');
1616:

Line 1617: INSERT INTO cz_xfr_tables

1613: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1614: VALUES
1615: (20, 'SEQUENCES', '0', 'CZ_FILTER_SETS_S', 'CZ_FILTER_SETS', 'FILTER_SET_ID', '20');
1616:
1617: INSERT INTO cz_xfr_tables
1618: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1619: VALUES
1620: (22, 'SEQUENCES', '0', 'CZ_FUNC_COMP_SPECS_S', 'CZ_FUNC_COMP_SPECS', 'FUNC_COMP_ID', '20');
1621:

Line 1622: INSERT INTO cz_xfr_tables

1618: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1619: VALUES
1620: (22, 'SEQUENCES', '0', 'CZ_FUNC_COMP_SPECS_S', 'CZ_FUNC_COMP_SPECS', 'FUNC_COMP_ID', '20');
1621:
1622: INSERT INTO cz_xfr_tables
1623: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1624: VALUES
1625: (23, 'SEQUENCES', '0', 'CZ_GRID_CELLS_S', 'CZ_GRID_CELLS', 'GRID_CELL_ID', '20');
1626:

Line 1627: INSERT INTO cz_xfr_tables

1623: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1624: VALUES
1625: (23, 'SEQUENCES', '0', 'CZ_GRID_CELLS_S', 'CZ_GRID_CELLS', 'GRID_CELL_ID', '20');
1626:
1627: INSERT INTO cz_xfr_tables
1628: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1629: VALUES
1630: (24, 'SEQUENCES', '0', 'CZ_GRID_COLS_S', 'CZ_GRID_COLS', 'GRID_COL_ID', '20');
1631:

Line 1632: INSERT INTO cz_xfr_tables

1628: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1629: VALUES
1630: (24, 'SEQUENCES', '0', 'CZ_GRID_COLS_S', 'CZ_GRID_COLS', 'GRID_COL_ID', '20');
1631:
1632: INSERT INTO cz_xfr_tables
1633: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1634: VALUES
1635: (25, 'SEQUENCES', '0', 'CZ_GRID_DEFS_S', 'CZ_GRID_DEFS', 'GRID_ID', '20');
1636:

Line 1637: INSERT INTO cz_xfr_tables

1633: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1634: VALUES
1635: (25, 'SEQUENCES', '0', 'CZ_GRID_DEFS_S', 'CZ_GRID_DEFS', 'GRID_ID', '20');
1636:
1637: INSERT INTO cz_xfr_tables
1638: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1639: VALUES
1640: (26, 'SEQUENCES', '0', 'CZ_INTL_TEXTS_S', 'CZ_LOCALIZED_TEXTS', 'INTL_TEXT_ID', '20');
1641:

Line 1642: INSERT INTO cz_xfr_tables

1638: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1639: VALUES
1640: (26, 'SEQUENCES', '0', 'CZ_INTL_TEXTS_S', 'CZ_LOCALIZED_TEXTS', 'INTL_TEXT_ID', '20');
1641:
1642: INSERT INTO cz_xfr_tables
1643: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1644: VALUES
1645: (27, 'SEQUENCES', '0', 'CZ_ITEM_MASTERS_S', 'CZ_ITEM_MASTERS', 'ITEM_ID', '20');
1646:

Line 1647: INSERT INTO cz_xfr_tables

1643: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1644: VALUES
1645: (27, 'SEQUENCES', '0', 'CZ_ITEM_MASTERS_S', 'CZ_ITEM_MASTERS', 'ITEM_ID', '20');
1646:
1647: INSERT INTO cz_xfr_tables
1648: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1649: VALUES
1650: (30, 'SEQUENCES', '0', 'CZ_ITEM_TYPES_S', 'CZ_ITEM_TYPES', 'ITEM_TYPE_ID', '20');
1651:

Line 1652: INSERT INTO cz_xfr_tables

1648: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1649: VALUES
1650: (30, 'SEQUENCES', '0', 'CZ_ITEM_TYPES_S', 'CZ_ITEM_TYPES', 'ITEM_TYPE_ID', '20');
1651:
1652: INSERT INTO cz_xfr_tables
1653: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1654: VALUES
1655: (32, 'SEQUENCES', '0', 'CZ_LCE_HEADERS_S', 'CZ_LCE_HEADERS', 'LCE_HEADER_ID', '20');
1656:

Line 1657: INSERT INTO cz_xfr_tables

1653: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1654: VALUES
1655: (32, 'SEQUENCES', '0', 'CZ_LCE_HEADERS_S', 'CZ_LCE_HEADERS', 'LCE_HEADER_ID', '20');
1656:
1657: INSERT INTO cz_xfr_tables
1658: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1659: VALUES
1660: (33, 'SEQUENCES', '0', 'CZ_LCE_LINES_S', 'CZ_LCE_LINES', 'LCE_LINE_ID', '20');
1661:

Line 1662: INSERT INTO cz_xfr_tables

1658: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1659: VALUES
1660: (33, 'SEQUENCES', '0', 'CZ_LCE_LINES_S', 'CZ_LCE_LINES', 'LCE_LINE_ID', '20');
1661:
1662: INSERT INTO cz_xfr_tables
1663: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1664: VALUES
1665: (34, 'SEQUENCES', '0', 'CZ_LCE_OPERANDS_S', 'CZ_LCE_OPERANDS', 'OPERAND_SEQ', '20');
1666:

Line 1667: INSERT INTO cz_xfr_tables

1663: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1664: VALUES
1665: (34, 'SEQUENCES', '0', 'CZ_LCE_OPERANDS_S', 'CZ_LCE_OPERANDS', 'OPERAND_SEQ', '20');
1666:
1667: INSERT INTO cz_xfr_tables
1668: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1669: VALUES
1670: (35, 'SEQUENCES', '0', 'CZ_LOCALES_S', 'CZ_LOCALES', 'LOCALE_ID', '20');
1671:

Line 1672: INSERT INTO cz_xfr_tables

1668: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1669: VALUES
1670: (35, 'SEQUENCES', '0', 'CZ_LOCALES_S', 'CZ_LOCALES', 'LOCALE_ID', '20');
1671:
1672: INSERT INTO cz_xfr_tables
1673: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1674: VALUES
1675: (37, 'SEQUENCES', '0', 'CZ_MODEL_PUBLICATIONS_S', 'CZ_MODEL_PUBLICATIONS', 'PUBLICATION_ID', '20');
1676:

Line 1677: INSERT INTO cz_xfr_tables

1673: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1674: VALUES
1675: (37, 'SEQUENCES', '0', 'CZ_MODEL_PUBLICATIONS_S', 'CZ_MODEL_PUBLICATIONS', 'PUBLICATION_ID', '20');
1676:
1677: INSERT INTO cz_xfr_tables
1678: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1679: VALUES
1680: (38, 'SEQUENCES', '0', 'CZ_MODEL_REF_EXPLS_S', 'CZ_MODEL_REF_EXPLS', 'MODEL_REF_EXPL_ID', '20');
1681:

Line 1682: INSERT INTO cz_xfr_tables

1678: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1679: VALUES
1680: (38, 'SEQUENCES', '0', 'CZ_MODEL_REF_EXPLS_S', 'CZ_MODEL_REF_EXPLS', 'MODEL_REF_EXPL_ID', '20');
1681:
1682: INSERT INTO cz_xfr_tables
1683: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1684: VALUES
1685: (39, 'SEQUENCES', '0', 'CZ_MODEL_USAGES_S', 'CZ_MODEL_USAGES', 'MODEL_USAGE_ID', '1');
1686:

Line 1687: INSERT INTO cz_xfr_tables

1683: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1684: VALUES
1685: (39, 'SEQUENCES', '0', 'CZ_MODEL_USAGES_S', 'CZ_MODEL_USAGES', 'MODEL_USAGE_ID', '1');
1686:
1687: INSERT INTO cz_xfr_tables
1688: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1689: VALUES
1690: (40, 'SEQUENCES', '0', 'CZ_OPPORTUNITY_HDRS_S', 'CZ_OPPORTUNITY_HDRS', 'OPPORTUNITY_HDR_ID', '20');
1691:

Line 1692: INSERT INTO cz_xfr_tables

1688: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1689: VALUES
1690: (40, 'SEQUENCES', '0', 'CZ_OPPORTUNITY_HDRS_S', 'CZ_OPPORTUNITY_HDRS', 'OPPORTUNITY_HDR_ID', '20');
1691:
1692: INSERT INTO cz_xfr_tables
1693: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1694: VALUES
1695: (42, 'SEQUENCES', '0', 'CZ_PB_MODEL_EXPORTS_S', 'CZ_PB_MODEL_EXPORTS', 'EXPORT_ID', '1');
1696:

Line 1697: INSERT INTO cz_xfr_tables

1693: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1694: VALUES
1695: (42, 'SEQUENCES', '0', 'CZ_PB_MODEL_EXPORTS_S', 'CZ_PB_MODEL_EXPORTS', 'EXPORT_ID', '1');
1696:
1697: INSERT INTO cz_xfr_tables
1698: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1699: VALUES
1700: (43, 'SEQUENCES', '0', 'CZ_POPULATORS_S', 'CZ_POPULATORS', 'POPULATOR_ID', '20');
1701:

Line 1702: INSERT INTO cz_xfr_tables

1698: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1699: VALUES
1700: (43, 'SEQUENCES', '0', 'CZ_POPULATORS_S', 'CZ_POPULATORS', 'POPULATOR_ID', '20');
1701:
1702: INSERT INTO cz_xfr_tables
1703: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1704: VALUES
1705: (44, 'SEQUENCES', '0', 'CZ_POPULATOR_MAPS_S', 'CZ_POPULATOR_MAPS', 'POP_MAP_ID', '20');
1706:

Line 1707: INSERT INTO cz_xfr_tables

1703: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1704: VALUES
1705: (44, 'SEQUENCES', '0', 'CZ_POPULATOR_MAPS_S', 'CZ_POPULATOR_MAPS', 'POP_MAP_ID', '20');
1706:
1707: INSERT INTO cz_xfr_tables
1708: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1709: VALUES
1710: (46, 'SEQUENCES', '0', 'CZ_PRICE_GROUPS_S', 'CZ_PRICE_GROUPS', 'PRICE_GROUP_ID', '20');
1711:

Line 1712: INSERT INTO cz_xfr_tables

1708: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1709: VALUES
1710: (46, 'SEQUENCES', '0', 'CZ_PRICE_GROUPS_S', 'CZ_PRICE_GROUPS', 'PRICE_GROUP_ID', '20');
1711:
1712: INSERT INTO cz_xfr_tables
1713: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1714: VALUES
1715: (47, 'SEQUENCES', '0', 'CZ_PROPERTIES_S', 'CZ_PROPERTIES', 'PROPERTY_ID', '20');
1716:

Line 1717: INSERT INTO cz_xfr_tables

1713: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1714: VALUES
1715: (47, 'SEQUENCES', '0', 'CZ_PROPERTIES_S', 'CZ_PROPERTIES', 'PROPERTY_ID', '20');
1716:
1717: INSERT INTO cz_xfr_tables
1718: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1719: VALUES
1720: (48, 'SEQUENCES', '0', 'CZ_PROPOSAL_HDRS_S', 'CZ_PROPOSAL_HDRS', 'PROPOSAL_HDR_ID', '20');
1721:

Line 1722: INSERT INTO cz_xfr_tables

1718: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1719: VALUES
1720: (48, 'SEQUENCES', '0', 'CZ_PROPOSAL_HDRS_S', 'CZ_PROPOSAL_HDRS', 'PROPOSAL_HDR_ID', '20');
1721:
1722: INSERT INTO cz_xfr_tables
1723: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1724: VALUES
1725: (50, 'SEQUENCES', '0', 'CZ_PSNODE_PROPCOMPAT_GENS_S', 'CZ_PSNODE_PROPCOMPAT_GENS', 'COMPAT_RUN', '20');
1726:

Line 1727: INSERT INTO cz_xfr_tables

1723: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1724: VALUES
1725: (50, 'SEQUENCES', '0', 'CZ_PSNODE_PROPCOMPAT_GENS_S', 'CZ_PSNODE_PROPCOMPAT_GENS', 'COMPAT_RUN', '20');
1726:
1727: INSERT INTO cz_xfr_tables
1728: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1729: VALUES
1730: (51, 'SEQUENCES', '0', 'CZ_PS_NODES_S', 'CZ_PS_NODES', 'PS_NODE_ID', '20');
1731:

Line 1732: INSERT INTO cz_xfr_tables

1728: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1729: VALUES
1730: (51, 'SEQUENCES', '0', 'CZ_PS_NODES_S', 'CZ_PS_NODES', 'PS_NODE_ID', '20');
1731:
1732: INSERT INTO cz_xfr_tables
1733: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1734: VALUES
1735: (53, 'SEQUENCES', '0', 'CZ_QUOTE_HDRS_S', 'CZ_QUOTE_HDRS', 'QUOTE_HDR_ID', '20');
1736:

Line 1737: INSERT INTO cz_xfr_tables

1733: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1734: VALUES
1735: (53, 'SEQUENCES', '0', 'CZ_QUOTE_HDRS_S', 'CZ_QUOTE_HDRS', 'QUOTE_HDR_ID', '20');
1736:
1737: INSERT INTO cz_xfr_tables
1738: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1739: VALUES
1740: (56, 'SEQUENCES', '0', 'CZ_QUOTE_SPARES_S', 'CZ_QUOTE_SPARES', 'SEQ_NUMBER', '20');
1741:

Line 1742: INSERT INTO cz_xfr_tables

1738: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1739: VALUES
1740: (56, 'SEQUENCES', '0', 'CZ_QUOTE_SPARES_S', 'CZ_QUOTE_SPARES', 'SEQ_NUMBER', '20');
1741:
1742: INSERT INTO cz_xfr_tables
1743: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1744: VALUES
1745: (57, 'SEQUENCES', '0', 'CZ_QUOTE_SPECIAL_ITEMS_S', 'CZ_QUOTE_SPECIAL_ITEMS', 'SEQ_NUMBER', '20');
1746:

Line 1747: INSERT INTO cz_xfr_tables

1743: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1744: VALUES
1745: (57, 'SEQUENCES', '0', 'CZ_QUOTE_SPECIAL_ITEMS_S', 'CZ_QUOTE_SPECIAL_ITEMS', 'SEQ_NUMBER', '20');
1746:
1747: INSERT INTO cz_xfr_tables
1748: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1749: VALUES
1750: (58, 'SEQUENCES', '0', 'CZ_REL_TYPES_S', 'CZ_REL_TYPES', 'REL_TYPE_ID', '20');
1751:

Line 1752: INSERT INTO cz_xfr_tables

1748: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1749: VALUES
1750: (58, 'SEQUENCES', '0', 'CZ_REL_TYPES_S', 'CZ_REL_TYPES', 'REL_TYPE_ID', '20');
1751:
1752: INSERT INTO cz_xfr_tables
1753: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1754: VALUES
1755: (59, 'SEQUENCES', '0', 'CZ_RP_ENTRIES_S', 'CZ_RP_ENTRIES', 'OBJECT_ID', '20');
1756:

Line 1757: INSERT INTO cz_xfr_tables

1753: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1754: VALUES
1755: (59, 'SEQUENCES', '0', 'CZ_RP_ENTRIES_S', 'CZ_RP_ENTRIES', 'OBJECT_ID', '20');
1756:
1757: INSERT INTO cz_xfr_tables
1758: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1759: VALUES
1760: (60, 'SEQUENCES', '0', 'CZ_RULES_S', 'CZ_RULES', 'RULE_ID', '20');
1761:

Line 1762: INSERT INTO cz_xfr_tables

1758: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1759: VALUES
1760: (60, 'SEQUENCES', '0', 'CZ_RULES_S', 'CZ_RULES', 'RULE_ID', '20');
1761:
1762: INSERT INTO cz_xfr_tables
1763: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1764: VALUES
1765: (61, 'SEQUENCES', '0', 'CZ_RULE_FOLDERS_S', 'CZ_RULE_FOLDERS', 'RULE_FOLDER_ID', '20');
1766:

Line 1767: INSERT INTO cz_xfr_tables

1763: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1764: VALUES
1765: (61, 'SEQUENCES', '0', 'CZ_RULE_FOLDERS_S', 'CZ_RULE_FOLDERS', 'RULE_FOLDER_ID', '20');
1766:
1767: INSERT INTO cz_xfr_tables
1768: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1769: VALUES
1770: (62, 'SEQUENCES', '0', 'CZ_SERVERS_S', 'CZ_SERVERS', 'SERVER_LOCAL_ID', '20');
1771:

Line 1772: INSERT INTO cz_xfr_tables

1768: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1769: VALUES
1770: (62, 'SEQUENCES', '0', 'CZ_SERVERS_S', 'CZ_SERVERS', 'SERVER_LOCAL_ID', '20');
1771:
1772: INSERT INTO cz_xfr_tables
1773: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1774: VALUES
1775: (63, 'SEQUENCES', '0', 'CZ_SPARES_SPECIALS_S', 'CZ_SPARES_SPECIALS', 'PACKAGE_SEQ', '20');
1776:

Line 1777: INSERT INTO cz_xfr_tables

1773: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1774: VALUES
1775: (63, 'SEQUENCES', '0', 'CZ_SPARES_SPECIALS_S', 'CZ_SPARES_SPECIALS', 'PACKAGE_SEQ', '20');
1776:
1777: INSERT INTO cz_xfr_tables
1778: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1779: VALUES
1780: (64, 'SEQUENCES', '0', 'CZ_SUB_CON_SETS_S', 'CZ_SUB_CON_SETS', 'SUB_CONS_ID', '20');
1781:

Line 1782: INSERT INTO cz_xfr_tables

1778: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1779: VALUES
1780: (64, 'SEQUENCES', '0', 'CZ_SUB_CON_SETS_S', 'CZ_SUB_CON_SETS', 'SUB_CONS_ID', '20');
1781:
1782: INSERT INTO cz_xfr_tables
1783: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1784: VALUES
1785: (65, 'SEQUENCES', '0', 'CZ_TERMINATE_MSGS_S', 'CZ_TERMINATE_MSGS', 'MSG_ID', '20');
1786:

Line 1787: INSERT INTO cz_xfr_tables

1783: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1784: VALUES
1785: (65, 'SEQUENCES', '0', 'CZ_TERMINATE_MSGS_S', 'CZ_TERMINATE_MSGS', 'MSG_ID', '20');
1786:
1787: INSERT INTO cz_xfr_tables
1788: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1789: VALUES
1790: (66, 'SEQUENCES', '0', 'CZ_UI_DEFS_S', 'CZ_UI_DEFS', 'UI_DEF_ID', '20');
1791:

Line 1792: INSERT INTO cz_xfr_tables

1788: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1789: VALUES
1790: (66, 'SEQUENCES', '0', 'CZ_UI_DEFS_S', 'CZ_UI_DEFS', 'UI_DEF_ID', '20');
1791:
1792: INSERT INTO cz_xfr_tables
1793: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1794: VALUES
1795: (67, 'SEQUENCES', '0', 'CZ_UI_NODES_S', 'CZ_UI_NODES', 'UI_NODE_ID', '20');
1796:

Line 1797: INSERT INTO cz_xfr_tables

1793: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1794: VALUES
1795: (67, 'SEQUENCES', '0', 'CZ_UI_NODES_S', 'CZ_UI_NODES', 'UI_NODE_ID', '20');
1796:
1797: INSERT INTO cz_xfr_tables
1798: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1799: VALUES
1800: (70, 'SEQUENCES', '0', 'CZ_USER_GROUPS_S', 'CZ_USER_GROUPS', 'USER_GROUP_ID', '20');
1801:

Line 1802: INSERT INTO cz_xfr_tables

1798: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1799: VALUES
1800: (70, 'SEQUENCES', '0', 'CZ_USER_GROUPS_S', 'CZ_USER_GROUPS', 'USER_GROUP_ID', '20');
1801:
1802: INSERT INTO cz_xfr_tables
1803: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1804: VALUES
1805: (71, 'SEQUENCES', '0', 'CZ_XFR_PROJECT_BILLS_S', 'CZ_XFR_PROJECT_BILLS', 'MODEL_PS_NODE_ID', '-1');
1806:

Line 1807: INSERT INTO cz_xfr_tables

1803: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1804: VALUES
1805: (71, 'SEQUENCES', '0', 'CZ_XFR_PROJECT_BILLS_S', 'CZ_XFR_PROJECT_BILLS', 'MODEL_PS_NODE_ID', '-1');
1806:
1807: INSERT INTO cz_xfr_tables
1808: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1809: VALUES
1810: (72, 'SEQUENCES', '0', 'CZ_XFR_RUN_INFOS_S', 'CZ_XFR_RUN_INFOS', 'RUN_ID', '1');
1811:

Line 1814: INSERT INTO cz_xfr_tables

1810: (72, 'SEQUENCES', '0', 'CZ_XFR_RUN_INFOS_S', 'CZ_XFR_RUN_INFOS', 'RUN_ID', '1');
1811:
1812: --A. Tsyaston 14-Oct-2004 BUG 3937232 - Sequences added for synchronization.
1813:
1814: INSERT INTO cz_xfr_tables
1815: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1816: VALUES
1817: (73, 'SEQUENCES', '0', 'CZ_ARCHIVES_S', 'CZ_ARCHIVES', 'ARCHIVE_ID', '20');
1818:

Line 1819: INSERT INTO cz_xfr_tables

1815: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1816: VALUES
1817: (73, 'SEQUENCES', '0', 'CZ_ARCHIVES_S', 'CZ_ARCHIVES', 'ARCHIVE_ID', '20');
1818:
1819: INSERT INTO cz_xfr_tables
1820: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1821: VALUES
1822: (74, 'SEQUENCES', '0', 'CZ_SIGNATURES_S', 'CZ_SIGNATURES', 'SIGNATURE_ID', '20');
1823:

Line 1824: INSERT INTO cz_xfr_tables

1820: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1821: VALUES
1822: (74, 'SEQUENCES', '0', 'CZ_SIGNATURES_S', 'CZ_SIGNATURES', 'SIGNATURE_ID', '20');
1823:
1824: INSERT INTO cz_xfr_tables
1825: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1826: VALUES
1827: (75, 'SEQUENCES', '0', 'CZ_UI_ACTIONS_S', 'CZ_UI_ACTIONS', 'UI_ACTION_ID', '20');
1828:

Line 1829: INSERT INTO cz_xfr_tables

1825: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1826: VALUES
1827: (75, 'SEQUENCES', '0', 'CZ_UI_ACTIONS_S', 'CZ_UI_ACTIONS', 'UI_ACTION_ID', '20');
1828:
1829: INSERT INTO cz_xfr_tables
1830: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1831: VALUES
1832: (76, 'SEQUENCES', '0', 'CZ_UI_PAGES_S', 'CZ_UI_PAGES', 'PAGE_ID', '20');
1833:

Line 1834: INSERT INTO cz_xfr_tables

1830: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1831: VALUES
1832: (76, 'SEQUENCES', '0', 'CZ_UI_PAGES_S', 'CZ_UI_PAGES', 'PAGE_ID', '20');
1833:
1834: INSERT INTO cz_xfr_tables
1835: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1836: VALUES
1837: (77, 'SEQUENCES', '0', 'CZ_UI_PAGE_ELEMENTS_S', 'CZ_UI_PAGE_ELEMENTS', 'ELEMENT_ID', '20');
1838:

Line 1839: INSERT INTO cz_xfr_tables

1835: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1836: VALUES
1837: (77, 'SEQUENCES', '0', 'CZ_UI_PAGE_ELEMENTS_S', 'CZ_UI_PAGE_ELEMENTS', 'ELEMENT_ID', '20');
1838:
1839: INSERT INTO cz_xfr_tables
1840: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1841: VALUES
1842: (78, 'SEQUENCES', '0', 'CZ_UI_PAGE_REFS_S', 'CZ_UI_PAGE_REFS', 'PAGE_REF_ID', '20');
1843:

Line 1844: INSERT INTO cz_xfr_tables

1840: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1841: VALUES
1842: (78, 'SEQUENCES', '0', 'CZ_UI_PAGE_REFS_S', 'CZ_UI_PAGE_REFS', 'PAGE_REF_ID', '20');
1843:
1844: INSERT INTO cz_xfr_tables
1845: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1846: VALUES
1847: (79, 'SEQUENCES', '0', 'CZ_UI_PAGE_SETS_S', 'CZ_UI_PAGE_SETS', 'PAGE_SET_ID', '20');
1848:

Line 1849: INSERT INTO cz_xfr_tables

1845: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1846: VALUES
1847: (79, 'SEQUENCES', '0', 'CZ_UI_PAGE_SETS_S', 'CZ_UI_PAGE_SETS', 'PAGE_SET_ID', '20');
1848:
1849: INSERT INTO cz_xfr_tables
1850: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1851: VALUES
1852: (80, 'SEQUENCES', '0', 'CZ_UI_TEMPLATES_S', 'CZ_UI_TEMPLATES', 'TEMPLATE_ID', '20');
1853: