clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335483 fiddles created (27402 in the last week).

Select 'MAXIMO' as OWNER, 'SYS_C0019778' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"WONUM" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019779' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"STATUS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019780' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"STATUSDATE" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019781' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTDUR" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019782' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTLABHRS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019783' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTMATCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019784' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTLABCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019785' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTTOOLCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019786' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ACTLABHRS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019787' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ACTMATCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019788' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ACTLABCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019789' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ACTTOOLCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019790' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"HASCHILDREN" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019791' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"OUTLABCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019792' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"OUTMATCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019793' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"OUTTOOLCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019794' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"HISTORYFLAG" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019795' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"DOWNTIME" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019796' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"CHARGESTORE" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019797' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTSERVCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019798' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ACTSERVCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019799' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"DISABLED" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019800' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTATAPPRLABHRS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019801' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTATAPPRLABCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019802' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTATAPPRMATCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019803' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTATAPPRTOOLCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:44 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019804' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ESTATAPPRSERVCOST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019805' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"HASFOLLOWUPWORK" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019806' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ORGID" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019807' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"SITEID" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019808' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ISTASK" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019809' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"WOCLASS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019810' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"WOACCEPTSCHARGES" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019811' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PARENTCHGSSTATUS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019812' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"WORKORDERID" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019813' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"LANGCODE" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019814' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"INTERRUPTIBLE" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019815' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"HASLD" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019816' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"WOISSWAP" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019817' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"NEWCHILDCLASS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019818' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"SUSPENDFLOW" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019819' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"FLOWCONTROLLED" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019820' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"FLOWACTIONASSIST" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019821' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"ROWSTAMP" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019822' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"IGNORESRMAVAIL" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019823' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"IGNOREDIAVAIL" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019824' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"NESTEDJPINPROCESS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019825' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSCISMOBILE" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019826' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSCLOOP" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019827' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"INCTASKSINSCHED" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019828' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"REQASSTDWNTIME" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019829' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"APPTREQUIRED" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019830' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"AOS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019831' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"AMS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019832' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"LOS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019833' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"LMS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019834' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"REPAIRLOCFLAG" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019835' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSSISGIS" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019836' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSTMALERT" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019837' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSTFULLCOVERAGE" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019838' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSTREPORD" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019839' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSTDRIVERREQ" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019840' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSTWORKASSIGN" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019841' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSTLOCK" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019842' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSTACTMPPRICE" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019843' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"PLUSTMPTYPE" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019844' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"CGWOBILLABLE" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019845' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"CGWOASSETUPDATE" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL UNION ALL Select 'MAXIMO' as OWNER, 'SYS_C0019846' as CONSTRAINT_NAME, 'C' as CONSTRAINT_TYPE, 'WORKORDER' as TABLE_NAME, '"DJPAPPLIED" IS NOT NULL' as SEARCH_CONDITION_VC, NULL as R_OWNER, NULL as R_CONSTRAINT_NAME, NULL as DELETE_RULE, 'ENABLED' as STATUS, 'NOT DEFERRABLE' as DEFERRABLE, 'IMMEDIATE' as DEFERRED, 'VALIDATED' as VALIDATED, 'GENERATED NAME' as GENERATED, NULL as BAD, NULL as RELY, TO_DATE('11/24/2020 8:01:45 PM', 'MM/DD/YYYY HH:MI:SS AM') as LAST_CHANGE, NULL as INDEX_OWNER, NULL as INDEX_NAME, NULL as INVALID, NULL as VIEW_RELATED, 0 as ORIGIN_CON_ID FROM DUAL ;
OWNER CONSTRAINT_NAME CONSTRAINT_TYPE TABLE_NAME SEARCH_CONDITION_VC R_OWNER R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHANGE INDEX_OWNER INDEX_NAME INVALID VIEW_RELATED ORIGIN_CON_ID
MAXIMO SYS_C0019778 C WORKORDER "WONUM" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019779 C WORKORDER "STATUS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019780 C WORKORDER "STATUSDATE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019781 C WORKORDER "ESTDUR" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019782 C WORKORDER "ESTLABHRS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019783 C WORKORDER "ESTMATCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019784 C WORKORDER "ESTLABCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019785 C WORKORDER "ESTTOOLCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019786 C WORKORDER "ACTLABHRS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019787 C WORKORDER "ACTMATCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019788 C WORKORDER "ACTLABCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019789 C WORKORDER "ACTTOOLCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019790 C WORKORDER "HASCHILDREN" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019791 C WORKORDER "OUTLABCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019792 C WORKORDER "OUTMATCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019793 C WORKORDER "OUTTOOLCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019794 C WORKORDER "HISTORYFLAG" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019795 C WORKORDER "DOWNTIME" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019796 C WORKORDER "CHARGESTORE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019797 C WORKORDER "ESTSERVCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019798 C WORKORDER "ACTSERVCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019799 C WORKORDER "DISABLED" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019800 C WORKORDER "ESTATAPPRLABHRS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019801 C WORKORDER "ESTATAPPRLABCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019802 C WORKORDER "ESTATAPPRMATCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019803 C WORKORDER "ESTATAPPRTOOLCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019804 C WORKORDER "ESTATAPPRSERVCOST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019805 C WORKORDER "HASFOLLOWUPWORK" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019806 C WORKORDER "ORGID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019807 C WORKORDER "SITEID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019808 C WORKORDER "ISTASK" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019809 C WORKORDER "WOCLASS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019810 C WORKORDER "WOACCEPTSCHARGES" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019811 C WORKORDER "PARENTCHGSSTATUS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019812 C WORKORDER "WORKORDERID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019813 C WORKORDER "LANGCODE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019814 C WORKORDER "INTERRUPTIBLE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019815 C WORKORDER "HASLD" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019816 C WORKORDER "WOISSWAP" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019817 C WORKORDER "NEWCHILDCLASS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019818 C WORKORDER "SUSPENDFLOW" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019819 C WORKORDER "FLOWCONTROLLED" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019820 C WORKORDER "FLOWACTIONASSIST" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019821 C WORKORDER "ROWSTAMP" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019822 C WORKORDER "IGNORESRMAVAIL" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019823 C WORKORDER "IGNOREDIAVAIL" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019824 C WORKORDER "NESTEDJPINPROCESS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019825 C WORKORDER "PLUSCISMOBILE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019826 C WORKORDER "PLUSCLOOP" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019827 C WORKORDER "INCTASKSINSCHED" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019828 C WORKORDER "REQASSTDWNTIME" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019829 C WORKORDER "APPTREQUIRED" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019830 C WORKORDER "AOS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019831 C WORKORDER "AMS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019832 C WORKORDER "LOS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019833 C WORKORDER "LMS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019834 C WORKORDER "REPAIRLOCFLAG" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019835 C WORKORDER "PLUSSISGIS" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019836 C WORKORDER "PLUSTMALERT" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019837 C WORKORDER "PLUSTFULLCOVERAGE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019838 C WORKORDER "PLUSTREPORD" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019839 C WORKORDER "PLUSTDRIVERREQ" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019840 C WORKORDER "PLUSTWORKASSIGN" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019841 C WORKORDER "PLUSTLOCK" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019842 C WORKORDER "PLUSTACTMPPRICE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019843 C WORKORDER "PLUSTMPTYPE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019844 C WORKORDER "CGWOBILLABLE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019845 C WORKORDER "CGWOASSETUPDATE" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
MAXIMO SYS_C0019846 C WORKORDER "DJPAPPLIED" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME 24-NOV-20 0
 hidden batch(es)