database changes overview january 2009 sp2 vs...
TRANSCRIPT
SPMat 2008 6.3.2Database Changes Overview
SP2 vs SP1January 2009
®
1Page of
Database Changes Overview
40
Table NameA_TESTBACKUP_M_ITEM_SHIPSCCD_DELCC_DELEUL5_ACCESS_PRIVSEUL5_APP_PARAMSEUL5_ASMP_CONSEUL5_ASMP_LOGSEUL5_ASM_POLICIESEUL5_BA_OBJ_LINKSEUL5_BASEUL5_BATCH_PARAMSEUL5_BATCH_QUERIESEUL5_BATCH_REPORTSEUL5_BATCH_SHEETSEUL5_BQ_DEPSEUL5_BQ_TABLESEUL5_BR_RUNSEUL5_DBH_NODESEUL5_DOCUMENTSEUL5_DOMAINSEUL5_ELEM_XREFSEUL5_EUL_USERSEUL5_EXP_DEPSEUL5_EXPRESSIONSEUL5_FREQ_UNITSEUL5_FUN_ARGUMENTSEUL5_FUN_CTGSEUL5_FUNCTIONSEUL5_FUN_FC_LINKSEUL5_GATEWAYSEUL5_HIERARCHIESEUL5_HI_NODESEUL5_HI_SEGMENTSEUL5_IG_EXP_LINKSEUL5_IHS_FK_LINKSEUL5_KEY_CONSEUL5_OBJ_DEPSEUL5_OBJ_JOIN_USGSEUL5_OBJSEUL5_PLAN_TABLEEUL5_QPP_STATSEUL5_SEGMENTSEUL5_SEQUENCESEUL5_SQ_CRRLTNSEUL5_SUB_QUERIESEUL5_SUM_BITMAPS
New Tables:
2Page of
Database Changes Overview
40
Table NameEUL5_SUMMARY_OBJSEUL5_SUMO_EXP_USGSEUL5_SUM_RFSH_SETSEUL5_VERSIONSM_ALT_OPTIONSM_APPROVAL_USER_REPRSM_ASSEMBLIES_TONYM_ATT_ADDENDASM_ATT_APB_LABOR_HOURSM_ATT_PRICE_BREAKDOWNSM_ATT_PRICE_BREAKDOWNS_DUPLM_ATT_SOW_MSM_ATT_SOW_MS_DETAILSM_ATT_SOW_NLSM_ATT_SOWSM_CATALOG_ITEMSM_CATALOG_NLSM_CATALOGSM_CATALOG_SECTIONSM_CATSEC_EXTRA_PRICESM_CAT_SEC_PRICE_NAMESM_CAT_SECTION_DETAILSM_CAT_SECTION_GEOMSM_COMPANY_PRICE_TYPES_BAKM_DELV_STATUSM_DELV_STATUS_NLSM_DIVERSITY_CODE_NLSM_DIVERSITY_CODESM_ENG_COMM_ITEM_BIDDERSM_ENG_COMM_ITEM_NLSM_ENG_COMM_ITEM_RESPONSM_ENG_COMM_ITEM_STRATEGIESM_EST_CALCS_BAKM_EVAL_SELECTION_PROCESSESM_EVAL_SEL_PROCESS_NLSM_EXP_MSM_FORECAST_TRANS_RESULTSM_FUNCTION_LIST_NLSM_FUNCTION_LISTSM_FUNCTION_SET_DETAILSM_FUNCTION_SET_NLSM_FUNCTION_SETSM_GOOD_SERVICE_TYPE_NLSM_GOOD_SERVICE_TYPESMICROSOFTDTPROPERTIESM_INQ_PAS_BAKM_LOG_BROADCASTS
New Tables: cont'd
3Page of
Database Changes Overview
40
Table NameM_LOGIN_REQUEST_CONTACTSM_LOGIN_REQUESTSM_PRE_BID_MEETINGSM_PRICE_LIST_CATALOGSM_PRICE_LIST_ITEMSM_PRICE_NAME_ATTRSM_PRICES_BAKM_PRICING_TYPE_NLSM_PRICING_TYPESM_QUEST_ANSWERSM_QUESTIONSM_QUEST_MATERIAL_GROUPSM_QUEST_REVISIONSM_QUOTE_DETAILS_BACKUPM_REQ_BIDDERSM_SOURCING_STRATEGIESM_SOURCING_STRATEGY_NLSM_SOW_DETAILSM_SOW_DETAILS_NLSM_SOW_NLSM_SOWSM_SPW_DPM_CLASS_DETAILSM_SPW_TEMPLATE_ITEM_DETM_SP3D_EXP_JOB_DTA_CCI_TMPM_SP3D_EXP_JOB_DTA_SI_TMPM_SP3D_EXP_JOB_DTA_SP_TMPM_SP3D_EXP_JOB_DTA_TMPM_SP3D_IMP_BATCH_JOB_DETAILSM_SP3D_IMP_BATCH_JOBSM_TABLE_DETAIL_SCHEDULESM_TMP_INV_ITEMSM_TMP_NEW_PRJ_IDENTSM_TMP_SUBSTITUTIONSM_USER_CONS_COLUMNSPLAN_TABLEPS_TXNTEMP_M_DOCUMENTSTEMP_M_DOCUMENT_SETSTEMP_M_GEOM_NAME_NLSTEMP_M_GEOM_NAMESTOAD_PLAN_SQLTOAD_PLAN_TABLE
New Tables: cont'd
Table_Name
Removed Tables:
4Page of
Database Changes Overview
40
Table_NameCG_REF_CODES_BAK62M_ADM_MESSAGE_NLS_BAK62M_ADM_MESSAGES_BAK62M_ADM_MESS_LANGS_BAK62M_ADM_QUERY_MODULES_BAK62M_APPL_MENU_BLOCK_ITEMS_BAK62M_APPL_MENU_BLOCKS_BAK62M_APPL_MENU_CIP_REFS_BAK62M_APPL_MENU_DBA_SETS_BAK62M_APPL_MENU_FCS_BAK62M_APPL_MENU_FIELDS_BAK62M_APPL_MENU_LIC_MODULES_BAK62M_APPL_MENU_LOV_DETAILS_BAK62M_APPL_MENU_LOVS_BAK62M_APPL_MENU_NLS_BAK62M_APPL_MENU_PARM_BAK62M_APPL_MENU_PRIVS_BAK62M_APPL_MENUS_BAK62M_APPL_MENU_TAB_PAGES_BAK62M_APPL_PARM_BAK62M_APPL_PARM_NLS_BAK62M_APPL_PARM_VALUE_DET_BAK62M_APPL_PARM_VALUES_BAK62M_APPL_ROLE_NLS_BAK62M_APPL_ROLES_BAK62M_CCM_TABLES_BAK62M_DATA_DICTIONARY_NOM_BAK62M_DBA_CIP_REFS_BAK62M_DBA_CIPS_BAK62M_DBA_INSTALL_STATUS_BAK62M_DBA_SETTING_NLS_BAK62M_DBA_SETTINGS_BAK62M_LIC_MODULES_BAK62M_MARIAN_THEME_COLORS_BAK62M_MENU_REPORTS_BAK62M_MODULE_NOMINAL_VER_BAK62M_NLS_BAK62M_PACKAGE_NOMINAL_VERS_BAK62M_PDSI_CL_ATTR_DMPS_BAK62M_PDSI_CL_TD_DMPS_BAK62M_PDSI_MODEL_PIP_DMPS_BAK62M_PDSI_ZYDEX_SHTCD_PART_BAK62M_PDS_PCD_RULES_BAK62M_PDS_RULES_BAK62M_PRIV_NLS_BAK62M_PRIVS_BAK62M_PROMPT_FIELDS_BAK62M_PROMPTS_BAK62
Removed Tables: cont'd
5Page of
Database Changes Overview
40
Table_NameM_SAP_IDOC_FIELD_NLS_BAK62M_SAP_IDOC_FIELDS_BAK62M_SAP_IDOC_NLS_BAK62M_SAP_IDOCS_BAK62M_SAP_IDOC_SEGMENT_NLS_BAK62M_SAP_IDOC_SEGMENTS_BAK62M_SAP_VERSION_NLS_BAK62M_SAP_VERSIONS_BAK62M_SP3D_ATTRS_BAK62M_SP3D_CAT_STRUCT_ELEMS_BAK62M_SP3D_CAT_STRUCT_E_SHTS_BAK62M_SP3D_CAT_STRUCTS_BAK62M_SP3D_GEN_CONF_ITEMS_BAK62M_SP3D_GEN_CONF_IT_V_BAK62M_SP3D_GEN_CONFS_BAK62M_SP3D_IMP_CONF_ITEMS_BAK62M_SP3D_IMP_CONF_I_V_BAK62M_SP3D_IMP_CONFS_BAK62M_SP3D_PROCEDURES_BAK62M_SP3D_RTRV_SOURCES_BAK62M_SP3D_SHT_CONFS_BAK62M_SP3D_SHT_CONF_SHT_A_BAK62M_SP3D_SHT_CONF_SHT_D_A_BAK62M_SP3D_SHT_CONF_SHTS_BAK62M_SP3D_SHTS_BAK62M_SP3D_TPLS_BAK62M_SP3D_TPL_SHT_DTA_BAK62M_SP3D_TPL_SHT_DTA_SP_BAK62M_SP3D_TPL_SHTS_BAK62M_SP3D_TRANS_TYPES_BAK62M_SP3D_TRANS_TYPE_SHTS_BAK62XI_E1BPEBANCXI_E1BPEBANTXXI_E1BPEBKNXI_E1BPESKLCXI_E1BPESLLCXI_E1BPESUCCXI_E1BPESUHCXI_E1MAKTMXI_E1MARAMXI_E1MARA1XI_E1MARCMXI_E1MARC1XI_E1MARDMXI_E1MARMMXI_E1MBEWMXI_E1MEANMXI_E1MFHMM
Removed Tables: cont'd
6Page of
Database Changes Overview
40
Table_NameXI_E1MKALMXI_E1MLANMXI_E1MLGNMXI_E1MLGTMXI_E1MPGDMXI_E1MPOPMXI_E1MPRWMXI_E1MTXHMXI_E1MTXLMXI_E1MVEGMXI_E1MVEUMXI_E1MVKEMXI_E1OCLFM
Removed Tables: cont'd
7Page of
Database Changes Overview
40
View NameEUL5_NAMED_ELEMSEUL5_ODBC_CATALOGSEUL5_ODBC_SCHEMASMV_APPROVAL_PK_TYPESMV_COMP_SECURITYMV_LOGIN_REQUEST_CONTACTSMV_LOGIN_REQUESTSMV_LR_SECURITYMV_MAPPED_TOMVP_ALT_OPTIONSMVP_APPROVAL_OBJ_AWAITSMVP_APPROVAL_USER_REPRSMVP_ATT_ADDENDASMVP_ATT_APB_LABOR_HOURSMVP_ATT_PRICE_BREAKDOWNSMVP_ATT_SOW_MSMVP_ATT_SOW_MS_DETAILSMVP_ATT_SOWSMVP_CATALOG_ITEMSMVP_CATALOGSMVP_CATALOG_SECTIONSMVP_CATSEC_EXTRA_PRICESMVP_CAT_SEC_PRICE_NAMESMVP_CAT_SECTION_DETAILSMVP_CAT_SECTION_GEOMSMVP_DELV_STATUSMVP_ENG_COMM_ITEM_BIDDERSMVP_ENG_COMM_ITEM_RESPONSMVP_ENG_COMM_ITEM_STRATEGIESMVP_EVAL_SELECTION_PROCESSESMVP_FUNCTION_LISTSMVP_FUNCTION_SET_DETAILSMVP_FUNCTION_SETSMVP_GOOD_SERVICE_TYPESMVP_PICS_HEAT_DETAILSMVP_PRE_BID_MEETINGSMVP_PRICE_LIST_CATALOGSMVP_PRICE_LIST_ITEMSMVP_PRICE_NAME_ATTRSMVP_PRICING_TYPESMVP_REQ_BIDDERSMVP_SOURCING_STRATEGIESMVP_SOW_DETAILSMVP_SOWSMVP_SPW_DPM_CLASS_DETAILSMVP_SPW_TEMPLATE_ITEM_DETMVP_SP3D_IMP_BATCH_JOB_DETAILS
New Views:
8Page of
Database Changes Overview
40
Table Name
New Colums added:
M_APPROVAL_TEMPLATE_DETAILSM_APPROVAL_TEMPLATE_DETAILSM_APPROVAL_TEMPLATE_DETAILSM_APPROVAL_USERSM_APPROVAL_USERSM_APPROVAL_USERSM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_ATT_RATE_TYPESM_BOM_COMP_STRUC_DETAILS_BAKM_BOM_COMP_STRUCS_BAKM_COMMUNICATION_TYPES
Column Name Data Type LengthNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERVARCHAR2NUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERVARCHAR2
2222222222222222255222222222222222222222222222222221
AMOUNTCURRENCY_IDDISTRIB_IDAMOUNTCURRENCY_IDDISTRIB_IDDOUBLE_TIMEMOBILIZEOTHEROVERTIMEPERCNT_FRING_BENEFITSPERCNT_GEN_AND_ADMPERCNT_OVERH_AND_PROFPERCNT_PAYROLL_TAXESPERCNT_SMTOOL_AND_CONSUMPERCNT_WOCOMP_AND_LIABINSPER_DAYPER_HOURPER_MONTHPER_WEEKQTY_ALLOWANCESHIFT_DIFFERENTIALUNIT_IDDC_IDDC_IDCMT_EMAIL_IND
View NameMVP_SP3D_IMP_BATCH_JOBSMVP_TABLE_DETAIL_SCHEDULESMVP_TRANS_HEAT_DETAILSMV_QUALIFICATION_ESUPSMV_QUESTIONNAIREMV_QUESTIONSMV_REQ_ORDER_TYPESMV_SPEC_ITEM_IDENT_ALLMV_SPEC_ITEM_IDENT1MV_SPEC_ITEM_IDENT2MV_SPEC_ITEM_IDENT3MV_SPEC_ITEM_IDENT4MV_SPEC_ITEM_IDENT5PIPE_SUMMARY_POSPIPE_WEIGHT
New Views: cont'd
9Page of
Database Changes Overview
40
Table Name
New Colums added: cont'd
M_COMPANIESM_COMPANIESM_COMPANY_PRICE_TYPESM_COMPANY_PRICE_TYPESM_COMPANY_PRICE_TYPESM_COMPANY_PRICE_TYPESM_COMPANY_PRICE_TYPESM_COMPANY_TYPESM_DBA_CIPS_BAKM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_EST_CALCSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORT_REFSM_FLAT_PRE_IMPORTSM_FLAT_PRE_IMPORTSM_FLAT_PRE_IMPORTSM_FLAT_PRE_IMPORTSM_FLAT_PRE_IMPORTSM_FLAT_PRE_IMPORTSM_FLAT_PRE_IMPORTSM_FLAT_PRE_IMPORTSM_FLAT_PRE_IMPORTSM_FLAT_PRE_IMPORTSM_FLAT_PRE_IMPORTSM_HEAT_DETAILSM_INQ_PASM_INQ_SUPPLIERSM_INQ_SUPPLIERSM_INQUIRIES
Column Name Data Type LengthVARCHAR2NUMBERVARCHAR2NUMBERNUMBERNUMBERNUMBERVARCHAR2VARCHAR2NUMBERNUMBERNUMBERNUMBERVARCHAR2VARCHAR2NUMBERVARCHAR2DATEDATEDATENUMBERVARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2NUMBERNUMBERVARCHAR2VARCHAR2DATE
4022122222222112822222222322217772266666666666666666666662222117
BUSINESS_REGISTRATIONCY_IDACTIVE_INDCPRT_IDKEY_FACTORPLC_IDSUP_PRIORITYSUPPLIER_INDCIP_NAMEAGREEMENT_BUDGETCURRENCY_IDGST_IDINQ_IDORDER_SUB_TYPEORDER_TYPEPTY_IDR_TYPESCHEDULED_AWARD_DATESCHEDULED_COMPLETION_DATESCHEDULED_MOBILIZE_DATECPRT_IDPOS_MAINPOS_SUB01POS_SUB02POS_SUB03POS_SUB04POS_SUB05POS_SUB06POS_SUB07POS_SUB08POS_SUB09POS_SUB10POS_MAINPOS_SUB01POS_SUB02POS_SUB03POS_SUB04POS_SUB05POS_SUB06POS_SUB07POS_SUB08POS_SUB09POS_SUB10IVI_IDCPRT_IDACCEPTED_INDEVALUATE_INDBID_NOI_DUE_DATE
10Page of
Database Changes Overview
40
Table Name
New Colums added: cont'd
M_INQUIRIESM_INQUIRIESM_INQUIRIESM_INQUIRIESM_INQUIRIESM_INQUIRIESM_INQUIRIESM_MERGE_COMPANY_JOBSM_MERGE_COMPANY_JOBSM_OMI_IMPORT_JOBSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PRELIM_PACKAGESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICES
Column Name Data Type LengthVARCHAR2NUMBERVARCHAR2VARCHAR2NUMBERVARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2NUMBERVARCHAR2NUMBERVARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2NUMBERNUMBERVARCHAR2DATEVARCHAR2VARCHAR2DATEDATENUMBERDATEVARCHAR2VARCHAR2VARCHAR2VARCHAR2NUMBERVARCHAR2NUMBERVARCHAR2DATEVARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2
20223222120001113220222022111111222240714077227312122255224071401255255255255255
BID_REQ_RETURN_TIMEBUDGETORDER_SUB_TYPEORDER_TYPEPTY_IDREQ_BIDDER_APRV_INDSUPPL_CAUSELRE_IND_1LRE_IND_2CHECK_CONSISTENCY_INDBUSINESS_SIZECT_CODECT_IDDVC_CODEDVC_IDHUBZONE_INDOMOB_INDSDB_INDSDVOSB_INDVOSB_INDWOSB_INDBOND_PREMIUM_AMOUNTCOMMITMENT_LIMITC_SIGNED_BYC_SIGNED_DATEC_SIGNED_INDC_TITLEEFFECTIVE_DATEEXPIRATION_DATEMG_IDNOTICE_TO_PROCEED_DATEORDER_SUB_TYPEPAYMENT_BOND_RQD_INDPAYMENT_TYPEPERFORMANCE_BOND_RQD_INDPTY_IDRETENTION_COMMENTRETENTION_PERCENTSC_SIGNED_BYSC_SIGNED_DATESC_SIGNED_INDSC_TITLELOCK_INDATTR_CHAR10ATTR_CHAR11ATTR_CHAR12ATTR_CHAR13ATTR_CHAR14
11Page of
Database Changes Overview
40
Table Name
New Colums added: cont'd
M_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICES
Column Name Data Type LengthVARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2NUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBER
25525525525525525525525525525525525525525525525525525525525525525525525525525525525525525525525522222222222222222222222222222222
ATTR_CHAR15ATTR_CHAR16ATTR_CHAR17ATTR_CHAR18ATTR_CHAR19ATTR_CHAR20ATTR_CHAR21ATTR_CHAR22ATTR_CHAR23ATTR_CHAR24ATTR_CHAR25ATTR_CHAR26ATTR_CHAR27ATTR_CHAR28ATTR_CHAR29ATTR_CHAR30ATTR_CHAR31ATTR_CHAR32ATTR_CHAR33ATTR_CHAR34ATTR_CHAR35ATTR_CHAR36ATTR_CHAR37ATTR_CHAR38ATTR_CHAR39ATTR_CHAR4ATTR_CHAR40ATTR_CHAR5ATTR_CHAR6ATTR_CHAR7ATTR_CHAR8ATTR_CHAR9ATTR_NUM10ATTR_NUM11ATTR_NUM12ATTR_NUM13ATTR_NUM14ATTR_NUM15ATTR_NUM16ATTR_NUM17ATTR_NUM18ATTR_NUM19ATTR_NUM20ATTR_NUM21ATTR_NUM22ATTR_NUM23ATTR_NUM24ATTR_NUM25
12Page of
Database Changes Overview
40
Table Name
New Colums added: cont'd
M_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICESM_PRICE_TYPESM_PRICE_TYPESM_PRICE_TYPESM_PROJECTSM_QUOTE_SUMMARIESM_RATE_TYPESM_REQSM_REQSM_REQSM_REQSM_REQ_TO_BOM_HISTS
Column Name Data Type LengthNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERVARCHAR2NUMBERVARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2DATEVARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2NUMBERVARCHAR2NUMBER
2222222222222222222222222222222222222222222212210101010101010101010111712551123222122
ATTR_NUM26ATTR_NUM27ATTR_NUM28ATTR_NUM29ATTR_NUM30ATTR_NUM31ATTR_NUM32ATTR_NUM33ATTR_NUM34ATTR_NUM35ATTR_NUM36ATTR_NUM37ATTR_NUM38ATTR_NUM39ATTR_NUM4ATTR_NUM40ATTR_NUM5ATTR_NUM6ATTR_NUM7ATTR_NUM8ATTR_NUM9CPRT_IDMANUAL_INDPLI_IDPRICE_STAT1PRICE_STAT10PRICE_STAT2PRICE_STAT3PRICE_STAT4PRICE_STAT5PRICE_STAT6PRICE_STAT7PRICE_STAT8PRICE_STAT9RELEASED_INDUSED_IN_BOMUSED_IN_SPECASSIGN_PRICE_TIMEINCLUDE_CATLOG_FILE_NAMECONFIDENTIAL_INDWILL_BID_INDRT_GRPORDER_SUB_TYPEORDER_TYPEPTY_IDR_TYPELP_QTY_ASS
13Page of
Database Changes Overview
40
Table Name
New Colums added: cont'd
M_REQUEST_FOR_USERSM_REQUEST_FOR_USERSM_SITE_EXP_DETAILS_BAKM_SP3D_IMP_JOB_DTA_CCIM_SP3D_SHT_CONF_SHTSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_TERMSM_USERSM_USERSM_USER_SECURITIES
Column Name Data Type LengthNUMBERNUMBERNUMBERNUMBERVARCHAR2VARCHAR2NUMBERVARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2NUMBERNUMBERVARCHAR2
22222222132221111114022221
AMOUNTCURRENCY_IDDC_IDXLS_BLOCKEXT_CUST_INDBUSINESS_SIZEDVC_IDHUBZONE_INDOMOB_INDSDB_INDSDVOSB_INDVOSB_INDWOSB_INDUSE_PARAMAMOUNTCURRENCY_IDAPI_IND
Table Name
Columns removed:
M_BOM_COMP_STRUC_DETAILS_BAKM_BOM_COMP_STRUCS_BAKM_DBA_CIPS_BAKM_EST_CALCSM_EST_CALCSM_INQ_PASM_INQ_PASM_INQ_PASM_PRICESM_PRICESM_PRICESM_SITE_EXP_DETAILS_BAK
Column Name Data Type LengthNUMBERNUMBERVARCHAR2NUMBERVARCHAR2NUMBERVARCHAR2NUMBERNUMBERVARCHAR2NUMBERNUMBER
22222000222022202222202222
DCR_IDDCR_IDCIP_DESCRIPTIONPRT_IDSHORT_DESCCOMPANY_IDSHORT_DESCPRT_IDCOMPANY_IDSHORT_DESCPRT_IDDCR_ID
14Page of
Database Changes Overview
40
Table Name
Datatypes change:
BAK_SERVICE_PACKS
M_APPROVAL_USERS
M_APPROVAL_USERS
M_BOM_PROCEDURES
M_SERVICE_PACKS
M_S5006_CONFIGS
MVI_TINV_TEMP_IDENTS
MVI_TINV_TEMP_IDENTS
MVI_TINV_TEMP_IDENTS
MVI_TINV_TEMP_IDENTS
MVI_TINV_TEMP_IDENTS
MVI_TINV_TEMP_IDENTS
MVI_TINV_TEMP_IDENTS
MVN_COMMODITY_GROUPS
MVN_COMMODITY_GROUPS
MVN_COMMODITY_GROUPS
MVN_COMMODITY_GROUPS
MVN_COMMODITY_GROUPS
MVN_COMMODITY_GROUPS
MVN_COMMODITY_GROUPS
MVN_DICT_TABS
MVN_DICT_TABS
MVN_DICT_TABS
MVN_DICT_TABS
MVN_DICT_TABS
MVN_DICT_TABS
MVN_DICT_TABS
MVN_PARTS
MVN_PARTS
MVN_PARTS
MVN_PARTS
MVN_PARTS
MVN_PARTS
MVN_PARTS
MVN_PARTS
MVN_PARTS
MVN_PARTS
MVN_PARTS
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
Column Name Data Type LengthTIMESTAMP(6)
VARCHAR2
NUMBER
VARCHAR2
DATE
VARCHAR2
NUMBER
NUMBER
VARCHAR2
VARCHAR2
VARCHAR2
VARCHAR2
VARCHAR2
NUMBER
VARCHAR2
VARCHAR2
NUMBER
NUMBER
VARCHAR2
VARCHAR2
VARCHAR2
VARCHAR2
NUMBER
VARCHAR2
NUMBER
VARCHAR2
NUMBER
NUMBER
NUMBER
VARCHAR2
NUMBER
VARCHAR2
DATE
DATE
VARCHAR2
NUMBER
VARCHAR2
NUMBER
VARCHAR2
VARCHAR2
NUMBER
VARCHAR2
NUMBER
11
10
22
1
7
1
22
22
60
60
60
60
60
22
60
20
22
22
10
10
10
30
22
255
22
20
22
22
22
20
22
60
7
7
10
22
40
22
2000
255
22
10
22
SVP_DATE
PROJ_ID
DP_ID
BOM_SA_IND
SVP_DATE
SKIP_GRP_PRT_IND
COMMODITY_ID
USY_ID
IN1
IN2
IN3
IN5
IN4
DP_ID
DESCRIPTION
SHORT_DESC
NLS_ID
GROUP_ID
PROJ_ID
GROUP_CODE
PROJ_ID
TABLE_NAME
TAB_ID
DESCRIPTION
NLS_ID
SHORT_DESC
DTT_ID
GROUP_ID
CONTROL_STATUS
SHORT_DESC
NLS_ID
DESCRIPTION
REV_END
REV_BEGIN
PROJ_ID
PART_ID
PART_CODE
DP_ID
TGN_DESCRIPTION
TGN_SHORT_DESC
DP_ID
TABLE_GROUP_CODE
TAB_GROUP_ID
N
Y
Y
N
N
N
N
N
N
N
N
N
N
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Null-able
15Page of
Database Changes Overview
40
Table Name
Datatypes change: cont'd
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
MVN_TABLE_DETAILS
MVN_TABLE_GROUPS
MVN_TABLE_GROUPS
MVN_TABLE_GROUPS
MVN_TABLE_GROUPS
MVN_TABLE_GROUPS
MVN_TABLE_GROUPS
MVN_TABLE_GROUPS
MVN_TABLE_GROUPS
MVP_APPROVAL_USERS
MVP_APPROVAL_USERS
MVP_BOM_PROCEDURES
MVP_EC_WORKLOAD
MVP_EC_WORKLOAD
MVP_SERVICE_PACKS
MVP_S5006_CONFIGS
Column Name Data Type LengthNUMBER
VARCHAR2
NUMBER
VARCHAR2
VARCHAR2
VARCHAR2
VARCHAR2
NUMBER
NUMBER
NUMBER
VARCHAR2
VARCHAR2
VARCHAR2
NUMBER
VARCHAR2
NUMBER
NUMBER
VARCHAR2
VARCHAR2
VARCHAR2
VARCHAR2
DATE
VARCHAR2
22
30
22
40
10
255
2000
22
22
22
2000
255
10
22
30
22
22
10
1
3
3
7
1
TAB_ID
TABLE_NAME
TD_ID
TD_CODE
PROJ_ID
TDN_SHORT_DESC
TDN_DESCRIPTION
NLS_ID
DP_ID
NLS_ID
DESCRIPTION
SHORT_DESC
TABLE_GROUP_CODE
TAB_GROUP_ID
TABLE_NAME
TAB_ID
DP_ID
PROJ_ID
BOM_SA_IND
ORDER_TYPE_NO_SCROLL
ORDER_TYPE
SVP_DATE
SKIP_GRP_PRT_IND
Constraint Name
Constraints removed:
AVCON_1212472892_PK_TY_005AVCON_1212472891_PK_TY_000AVCON_1212472892_PK_TY_004AVCON_1217587741_PK_TY_000AVCON_1212472891_PK_TY_002AVCON_1212472891_PK_TY_004AVCON_1212472892_PK_TY_002AVCON_1212472892_PK_TY_003AVCON_1161255466_BOM_S_000AVCON_1161252562_BOM_S_000CCP_CCP2_UKAVCON_1086595691_PO_SU_000AVCON_1086595691_R_SUP_001AVCON_1086595692_PO_SU_000AVCON_1086595692_R_SUP_000EC_PRT_FK
Table Name Constraint TypeCCCCCCCCCCUCCCCR
M_APPROVAL_TEMPLATESM_APPROVAL_USERSM_ATT_DOC_TYPE_SETSM_ATT_DOCUMENTSM_ATT_MILESTONESM_ATT_PPESM_ATT_TERMSM_ATT_VDRSM_BOM_MACROSM_BOM_PROCEDURESM_COMPANY_CONTACT_PEOPLEM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_NON_COMM_ITEMSM_ENG_NON_COMM_ITEMSM_EST_CALCS
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
N
Y
Y
N
N
Null-able
16Page of
Database Changes Overview
40
Constraint Name
Constraints removed: cont'd
AVCON_1212472891_PK_TY_003AVCON_1212472891_PK_TY_001INQPA_C_FKINQPA_PRT_FKAVCON_1086595693_I_SUP_000AVCON_1086595691_REVIS_003AVCON_1086595692_REVIS_003AVCON_1086595693_REVIS_010AVCON_1086595687_INCLU_001AVCON_1086595687_PO_SU_000AVCON_1086595687_REVIS_001AVCON_1191319985_ORDER_000AVCON_1086595692_FIRST_000AVCON_1086595692_LAST__000AVCON_1086595691_SHIPP_000AVCON_1086595691_SHIPP_002AVCON_1086595690_R_SUP_000AVCON_1086595691_R_SUP_000AVCON_1086595691_REVIS_001AVCON_1212472891_ORDER_003AVCON_1086595692_PO_SU_001AVCON_1212472892_ORDER_037AVCON_1206686853_R_SUP_000AVCON_1086595688_TFD_S_000
Table Name Constraint TypeCCRRCCCCCCCCCCCCCCCCCCCC
M_EXCEL_TEMPLATESM_FIND_CSSM_INQ_PASM_INQ_PASM_INQUIRIESM_MATL_ISSUE_RPTSM_MATL_RECEIPTSM_MATL_RECV_RPTSM_MTO_TYPESM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_LINE_ITEMSM_PO_LINE_ITEMSM_QUOTE_SUMMARIESM_QUOTE_SUMMARIESM_REQ_BALANCE_REQSM_REQSM_REQSM_SPF_PO_PUBLISHESM_SUP_PO_PERFSM_SUP_PO_PERFSM_TEMP_REQSM_TRAFFIC_FREEZE_DETAILS
Constraint Name
Constraints added:
EUL5_AP_CHECK_1EUL5_AP_CHECK_2EUL5_AP_EU_FKEUL5_AP_PKEUL5_AP_UK_1EUL5_GBA_BA_FKEUL5_GP_PRI_FKEUL5_GD_DOC_FKEUL5_APP_PKEUL5_APP_CHECK_1EUL5_APP_UK_1EUL5_AOC_OBJ_FKEUL5_APC_ASMP_FKEUL5_AUC_EU_FKEUL5_ASOC_SUMO_FKEUL5_APC_UK_1EUL5_APC_PKEUL5_APC_CHECK_2
Table Name Constraint TypeCCRPURRRPCURRRRUPC
EUL5_ACCESS_PRIVSEUL5_ACCESS_PRIVSEUL5_ACCESS_PRIVSEUL5_ACCESS_PRIVSEUL5_ACCESS_PRIVSEUL5_ACCESS_PRIVSEUL5_ACCESS_PRIVSEUL5_ACCESS_PRIVSEUL5_APP_PARAMSEUL5_APP_PARAMSEUL5_APP_PARAMSEUL5_ASMP_CONSEUL5_ASMP_CONSEUL5_ASMP_CONSEUL5_ASMP_CONSEUL5_ASMP_CONSEUL5_ASMP_CONSEUL5_ASMP_CONS
17Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
EUL5_APC_CHECK_1EUL5_APL_SUMO_FKEUL5_APL_PKEUL5_APL_CHECK_1EUL5_APL_ASMP_FKEUL5_ASMP_UK_1EUL5_ASMP_PKEUL5_ASMP_UK_2EUL5_BOL_UK_1EUL5_BOL_PKEUL5_BOL_OBJ_FKEUL5_BOL_BA_FKEUL5_BA_UK_2EUL5_BA_UK_1EUL5_BA_PKEUL5_BP_BS_FKEUL5_BP_PKEUL5_BP_UK_1EUL5_BQ_UK_1EUL5_BQ_PKEUL5_BQ_BS_FKEUL5_BR_UK_2EUL5_BR_UK_1EUL5_BR_RFU_FKEUL5_BR_EU_FKEUL5_BR_CHECK_2EUL5_BR_CHECK_1EUL5_BR_PKEUL5_BS_PKEUL5_BS_BR_FKEUL5_BS_UK_1EUL5_BFILD_FIL_FKEUL5_BQD_UK_1EUL5_BQD_PKEUL5_BQD_CHECK_1EUL5_BQD_BQ_FKEUL5_BID_IT_FKEUL5_BFUND_FUN_FKEUL5_BQT_UK_1EUL5_BQT_BRR_FKEUL5_BQT_PKEUL5_BQT_UK_2EUL5_BQT_BQ_FKEUL5_BRR_PKEUL5_BRR_BR_FKEUL5_BRR_UK_1EUL5_BRR_CHECK_1EUL5_DHN_UK_2
Table Name Constraint TypeCRPCRUPUUPRRUUPRPUUPRUURRCCPPRURUPCRRRURPURPRUCU
EUL5_ASMP_CONSEUL5_ASMP_LOGSEUL5_ASMP_LOGSEUL5_ASMP_LOGSEUL5_ASMP_LOGSEUL5_ASM_POLICIESEUL5_ASM_POLICIESEUL5_ASM_POLICIESEUL5_BA_OBJ_LINKSEUL5_BA_OBJ_LINKSEUL5_BA_OBJ_LINKSEUL5_BA_OBJ_LINKSEUL5_BASEUL5_BASEUL5_BASEUL5_BATCH_PARAMSEUL5_BATCH_PARAMSEUL5_BATCH_PARAMSEUL5_BATCH_QUERIESEUL5_BATCH_QUERIESEUL5_BATCH_QUERIESEUL5_BATCH_REPORTSEUL5_BATCH_REPORTSEUL5_BATCH_REPORTSEUL5_BATCH_REPORTSEUL5_BATCH_REPORTSEUL5_BATCH_REPORTSEUL5_BATCH_REPORTSEUL5_BATCH_SHEETSEUL5_BATCH_SHEETSEUL5_BATCH_SHEETSEUL5_BQ_DEPSEUL5_BQ_DEPSEUL5_BQ_DEPSEUL5_BQ_DEPSEUL5_BQ_DEPSEUL5_BQ_DEPSEUL5_BQ_DEPSEUL5_BQ_TABLESEUL5_BQ_TABLESEUL5_BQ_TABLESEUL5_BQ_TABLESEUL5_BQ_TABLESEUL5_BR_RUNSEUL5_BR_RUNSEUL5_BR_RUNSEUL5_BR_RUNSEUL5_DBH_NODES
18Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
EUL5_DHN_DBH_FKEUL5_DHN_PKEUL5_DHN_UK_1EUL5_DOC_CHECK_1EUL5_DOC_EU_FKEUL5_DOC_UK_1EUL5_DOC_UK_2EUL5_DOC_PKEUL5_DOM_PKEUL5_DOM_UK_1EUL5_DOM_IT_R_FKEUL5_DOM_IT_L_FKEUL5_DOM_CHECK_8EUL5_DOM_CHECK_7EUL5_DOM_CHECK_6EUL5_DOM_CHECK_5EUL5_DOM_CHECK_4EUL5_DOM_UK_2EUL5_DOM_CHECK_2EUL5_DOM_CHECK_3EUL5_EX_PKEUL5_EU_CHECK_1EUL5_EU_CHECK_2EUL5_EU_CHECK_3EUL5_EU_PKEUL5_EU_UK_2EUL5_PFD_FUN_FKEUL5_PSD_SQ_FKEUL5_PED_EXP_FKEUL5_PD_P_FKEUL5_ED_UK_1EUL5_ED_PKEUL5_ED_CHECK_1EUL5_CID_IT_FKEUL5_CFD_FUN_FKEUL5_CD_CI_FKEUL5_EXP_CHECK_4EUL5_CI_IT_FKEUL5_EXP_CHECK_6EUL5_EXP_CHECK_8EUL5_EXP_CHECK_9EUL5_EXP_PKEUL5_EXP_UK_1EUL5_EXP_UK_2EUL5_FIL_DOC_FKEUL5_FIL_OBJ_FKEUL5_IT_DOC_FKEUL5_IT_DOM_FK
Table Name Constraint TypeRPUCRUUPPURRCCCCCUCCPCCCPURRRRUPCRRRCRCCCPUURRRR
EUL5_DBH_NODESEUL5_DBH_NODESEUL5_DBH_NODESEUL5_DOCUMENTSEUL5_DOCUMENTSEUL5_DOCUMENTSEUL5_DOCUMENTSEUL5_DOCUMENTSEUL5_DOMAINSEUL5_DOMAINSEUL5_DOMAINSEUL5_DOMAINSEUL5_DOMAINSEUL5_DOMAINSEUL5_DOMAINSEUL5_DOMAINSEUL5_DOMAINSEUL5_DOMAINSEUL5_DOMAINSEUL5_DOMAINSEUL5_ELEM_XREFSEUL5_EUL_USERSEUL5_EUL_USERSEUL5_EUL_USERSEUL5_EUL_USERSEUL5_EUL_USERSEUL5_EXP_DEPSEUL5_EXP_DEPSEUL5_EXP_DEPSEUL5_EXP_DEPSEUL5_EXP_DEPSEUL5_EXP_DEPSEUL5_EXP_DEPSEUL5_EXP_DEPSEUL5_EXP_DEPSEUL5_EXP_DEPSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONS
19Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
EUL5_IT_FUN_FKEUL5_IT_OBJ_FKEUL5_JP_FK_FKEUL5_EXP_CHECK_3EUL5_EXP_CHECK_2EUL5_EXP_CHECK_15EUL5_EXP_CHECK_14EUL5_EXP_CHECK_13EUL5_EXP_CHECK_12EUL5_EXP_CHECK_11EUL5_EXP_CHECK_10EUL5_EXP_CHECK_1EUL5_EXP_CHECK_5EUL5_RFU_PKEUL5_RFU_UK_1EUL5_FA_UK_1EUL5_FA_CHECK_3EUL5_FA_CHECK_2EUL5_FA_CHECK_1EUL5_FA_UK_3EUL5_FA_UK_2EUL5_FA_FUN_FKEUL5_FA_PKEUL5_FC_UK_2EUL5_FC_UK_1EUL5_FC_CHECK_1EUL5_FC_PKEUL5_FUN_UK_2EUL5_FUN_UK_1EUL5_FUN_PKEUL5_FUN_CHECK_6EUL5_FUN_CHECK_5EUL5_FUN_CHECK_4EUL5_FUN_CHECK_3EUL5_FUN_CHECK_2EUL5_FUN_CHECK_1EUL5_FFL_FUN_FKEUL5_FFL_PKEUL5_FFL_UK_1EUL5_FFL_FC_FKEUL5_GW_CHECK_1EUL5_GW_PKEUL5_GW_CHECK_2EUL5_HI_CHECK_1EUL5_HI_CHECK_2EUL5_HI_CHECK_3EUL5_HI_PKEUL5_HI_UK_1
Table Name Constraint TypeRRRCCCCCCCCCCPUUCCCUURPUUCPUUPCCCCCCRPURCPCCCCPU
EUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_EXPRESSIONSEUL5_FREQ_UNITSEUL5_FREQ_UNITSEUL5_FUN_ARGUMENTSEUL5_FUN_ARGUMENTSEUL5_FUN_ARGUMENTSEUL5_FUN_ARGUMENTSEUL5_FUN_ARGUMENTSEUL5_FUN_ARGUMENTSEUL5_FUN_ARGUMENTSEUL5_FUN_ARGUMENTSEUL5_FUN_CTGSEUL5_FUN_CTGSEUL5_FUN_CTGSEUL5_FUN_CTGSEUL5_FUNCTIONSEUL5_FUNCTIONSEUL5_FUNCTIONSEUL5_FUNCTIONSEUL5_FUNCTIONSEUL5_FUNCTIONSEUL5_FUNCTIONSEUL5_FUNCTIONSEUL5_FUNCTIONSEUL5_FUN_FC_LINKSEUL5_FUN_FC_LINKSEUL5_FUN_FC_LINKSEUL5_FUN_FC_LINKSEUL5_GATEWAYSEUL5_GATEWAYSEUL5_GATEWAYSEUL5_HIERARCHIESEUL5_HIERARCHIESEUL5_HIERARCHIESEUL5_HIERARCHIESEUL5_HIERARCHIES
20Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
EUL5_HI_UK_2EUL5_IBH_DBH_FKEUL5_HN_IBH_FKEUL5_HN_PKEUL5_HN_UK_1EUL5_HN_UK_2EUL5_DHS_DBH_FKEUL5_DHS_DHN_C_FKEUL5_DHS_DHN_P_FKEUL5_HS_CHECK_1EUL5_HS_CHECK_2EUL5_HS_PKEUL5_HS_UK_1EUL5_IHS_HN_C_FKEUL5_IHS_HN_P_FKEUL5_IHS_IBH_FKEUL5_HIL_HN_FKEUL5_HIL_IT_FKEUL5_IEL_CHECK_1EUL5_IEL_PKEUL5_IEL_UK_1EUL5_KIL_IT_FKEUL5_KIL_KEY_FKEUL5_IFL_FK_FKEUL5_IFL_IHS_FKEUL5_IFL_PKEUL5_IFL_UK_1EUL5_KEY_CHECK_2EUL5_KEY_CHECK_3EUL5_KEY_CHECK_4EUL5_KEY_CHECK_5EUL5_KEY_CHECK_6EUL5_KEY_CHECK_7EUL5_KEY_CHECK_1EUL5_KEY_OBJ_FKEUL5_KEY_PKEUL5_KEY_UK_1EUL5_KEY_UK_2EUL5_FK_OBJ_FKEUL5_FK_UK_FKEUL5_KEY_CHECK_8EUL5_OD_UK_1EUL5_OD_PKEUL5_OD_OBJ_FKEUL5_OD_COBJ_FKEUL5_OD_CHECK_1EUL5_OJU_SUMO_FKEUL5_OJU_UK_1
Table Name Constraint TypeURRPUURRRCCPURRRRRCPURRRRPUCCCCCCCRPUURRCUPRRCRU
EUL5_HIERARCHIESEUL5_HIERARCHIESEUL5_HI_NODESEUL5_HI_NODESEUL5_HI_NODESEUL5_HI_NODESEUL5_HI_SEGMENTSEUL5_HI_SEGMENTSEUL5_HI_SEGMENTSEUL5_HI_SEGMENTSEUL5_HI_SEGMENTSEUL5_HI_SEGMENTSEUL5_HI_SEGMENTSEUL5_HI_SEGMENTSEUL5_HI_SEGMENTSEUL5_HI_SEGMENTSEUL5_IG_EXP_LINKSEUL5_IG_EXP_LINKSEUL5_IG_EXP_LINKSEUL5_IG_EXP_LINKSEUL5_IG_EXP_LINKSEUL5_IG_EXP_LINKSEUL5_IG_EXP_LINKSEUL5_IHS_FK_LINKSEUL5_IHS_FK_LINKSEUL5_IHS_FK_LINKSEUL5_IHS_FK_LINKSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_KEY_CONSEUL5_OBJ_DEPSEUL5_OBJ_DEPSEUL5_OBJ_DEPSEUL5_OBJ_DEPSEUL5_OBJ_DEPSEUL5_OBJ_JOIN_USGSEUL5_OBJ_JOIN_USGS
21Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
EUL5_OJU_PKEUL5_OJU_FK_FKEUL5_OJU_COBJ_FKEUL5_OJU_CHECK_2EUL5_OJU_CHECK_1EUL5_OBJ_BA_FKEUL5_OBJ_CHECK_1EUL5_OBJ_CHECK_2EUL5_OBJ_CHECK_3EUL5_OBJ_CHECK_4EUL5_OBJ_UK_2EUL5_OBJ_UK_1EUL5_OBJ_PKEUL5_QS_CHECK_1EUL5_QS_PKEUL5_QS_CHECK_3EUL5_QS_CHECK_2EUL5_SEG_CUO_FKEUL5_SEG_SDO_FKEUL5_SEG_CHECK_2EUL5_SEG_CHECK_1EUL5_SEG_BQ_FKEUL5_SEG_EXP_FKEUL5_SEG_OBJ_FKEUL5_SEG_PKEUL5_SEG_CHECK_3EUL5_SEG_SMS_FKEUL5_SEG_UK_1EUL5_SQC_IT_O_FKEUL5_SQC_IT_I_FKEUL5_SQC_PKEUL5_SQC_UK_1EUL5_SQC_SQ_FKEUL5_SQ_FIL_FKEUL5_SQ_UK_2EUL5_SQ_OBJ_FKEUL5_SQ_IT_FKEUL5_SQ_UK_1EUL5_SQ_PKEUL5_SB_UK_1EUL5_SB_FK_FKEUL5_SB_CHECK_1EUL5_SB_PKEUL5_SB_IT_FKEUL5_SB_FUN_FKEUL5_SUMO_UK_1EUL5_SUMO_PKEUL5_SUMO_CHECK_9
Table Name Constraint TypePRRCCRCCCCUUPCPCCRRCCRRRPCRURRPURRURRUPURCPRRUPC
EUL5_OBJ_JOIN_USGSEUL5_OBJ_JOIN_USGSEUL5_OBJ_JOIN_USGSEUL5_OBJ_JOIN_USGSEUL5_OBJ_JOIN_USGSEUL5_OBJSEUL5_OBJSEUL5_OBJSEUL5_OBJSEUL5_OBJSEUL5_OBJSEUL5_OBJSEUL5_OBJSEUL5_QPP_STATSEUL5_QPP_STATSEUL5_QPP_STATSEUL5_QPP_STATSEUL5_SEGMENTSEUL5_SEGMENTSEUL5_SEGMENTSEUL5_SEGMENTSEUL5_SEGMENTSEUL5_SEGMENTSEUL5_SEGMENTSEUL5_SEGMENTSEUL5_SEGMENTSEUL5_SEGMENTSEUL5_SEGMENTSEUL5_SQ_CRRLTNSEUL5_SQ_CRRLTNSEUL5_SQ_CRRLTNSEUL5_SQ_CRRLTNSEUL5_SQ_CRRLTNSEUL5_SUB_QUERIESEUL5_SUB_QUERIESEUL5_SUB_QUERIESEUL5_SUB_QUERIESEUL5_SUB_QUERIESEUL5_SUB_QUERIESEUL5_SUM_BITMAPSEUL5_SUM_BITMAPSEUL5_SUM_BITMAPSEUL5_SUM_BITMAPSEUL5_SUM_BITMAPSEUL5_SUM_BITMAPSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJS
22Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
EUL5_SUMO_CHECK_8EUL5_SUMO_CHECK_7EUL5_SUMO_CHECK_6EUL5_SUMO_CHECK_3EUL5_SUMO_CHECK_4EUL5_SUMO_CHECK_5EUL5_SUMO_CHECK_2EUL5_SUMO_CHECK_10EUL5_SUMO_CHECK_1EUL5_SUMO_ASMP_FKEUL5_SDO_SBO_FKEUL5_SBO_SRS_FKEUL5_SMIU_FUN_FKEUL5_SEU_CHECK_1EUL5_SEU_CHECK_2EUL5_SEU_CHECK_3EUL5_SEU_PKEUL5_SEU_SUMO_FKEUL5_SEU_UK_1EUL5_SFU_FUN_FKEUL5_SIU_IT_FKEUL5_SRS_PKEUL5_SRS_EU_FKEUL5_SRS_CHECK_3EUL5_SRS_CHECK_2EUL5_SRS_UK_1EUL5_SRS_RFU_FKEUL5_SRS_UK_2EUL5_SRS_CHECK_1AO_DP_FKAO_CURRENCY_FKAO_PKAO_PROJ_FKAO_UKAO_UK2AVCON_1222268931_AO_TY_000AVCON_1227775472_SEL_I_000AVCON_1222268931_ORDER_000AVCON_1224579560_PK_TY_000AVCON_1227775472_ADD_D_000AVCON_1227775472_INCLU_000ATD_UNIT_FKATD_DISTRIB_FKAVCON_1228998901_PK_TY_000AUR_FROM_USR_FKAUR_UKAUR_TO_USR_FKAUR_DP_FK
Table Name Constraint TypeCCCCCCCCCRRRRCCCPRURRPRCCURUCRRPRUUCCCCCCRRCRURR
EUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMMARY_OBJSEUL5_SUMO_EXP_USGSEUL5_SUMO_EXP_USGSEUL5_SUMO_EXP_USGSEUL5_SUMO_EXP_USGSEUL5_SUMO_EXP_USGSEUL5_SUMO_EXP_USGSEUL5_SUMO_EXP_USGSEUL5_SUMO_EXP_USGSEUL5_SUMO_EXP_USGSEUL5_SUM_RFSH_SETSEUL5_SUM_RFSH_SETSEUL5_SUM_RFSH_SETSEUL5_SUM_RFSH_SETSEUL5_SUM_RFSH_SETSEUL5_SUM_RFSH_SETSEUL5_SUM_RFSH_SETSEUL5_SUM_RFSH_SETSM_ALT_OPTIONSM_ALT_OPTIONSM_ALT_OPTIONSM_ALT_OPTIONSM_ALT_OPTIONSM_ALT_OPTIONSM_ALT_OPTIONSM_ALT_OPTIONSM_ALT_OPTIONSM_ALT_OPTIONSM_ALT_OPTIONSM_ALT_OPTIONSM_APPROVAL_TEMPLATE_DETAILSM_APPROVAL_TEMPLATE_DETAILSM_APPROVAL_TEMPLATESM_APPROVAL_USER_REPRSM_APPROVAL_USER_REPRSM_APPROVAL_USER_REPRSM_APPROVAL_USER_REPRS
23Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
AVCON_1229529017_PK_TY_000AUR_PKAUR_PROJ_FKAVCON_1228999222_PK_TY_000AU_UNIT_FKAU_DISTRIB_FKATTA_PKATTA_DP_FKATTA_PROJ_FKAVCON_1231323158_PK_TY_000AVCON_1231323158_ORDER_000AVCON_1231323158_I_SUP_000AVCON_1231323158_INCLU_000ATTA_UNIT_FKATTA_UKALH_ALH_UK1_UKALH_ALH_UK2_UKALH_APB_FKALH_CURCY_FKAVCON_1229966291_ORDER_000ALH_PKALH_PROJ_FKALH_RT_FKALH_DP_FKAVCON_1224579488_PK_TY_000AVCON_1224579458_PK_TY_000AVCON_1224579598_PK_TY_000AVCON_1224579687_PK_TY_000APB_CURRENCY_FKAPB_ACT_FKAVCON_1224579659_PK_TY_000APB_UKAPB_PROJ_FKAPB_PKAPB_JOB_FKAPB_DP_FKART_UNIT_FKASMS_DP_FKASMS_PKASMS_PROJ_FKASMS_UKAVCON_1227195502_PK_TY_000ASMS_ACT_FI_FKASMS_ACT_ST_FKASMS_ACT_SU_FKASMSD_ACT_FKASMSD_ASMS_FKASMSD_DP_FK
Table Name Constraint TypeCPRCRRPRRCCCCRUUURRCPRRRCCCCRRCURPRRRRPRUCRRRRRR
M_APPROVAL_USER_REPRSM_APPROVAL_USER_REPRSM_APPROVAL_USER_REPRSM_APPROVAL_USERSM_APPROVAL_USERSM_APPROVAL_USERSM_ATT_ADDENDASM_ATT_ADDENDASM_ATT_ADDENDASM_ATT_ADDENDASM_ATT_ADDENDASM_ATT_ADDENDASM_ATT_ADDENDASM_ATT_ADDENDASM_ATT_ADDENDASM_ATT_APB_LABOR_HOURSM_ATT_APB_LABOR_HOURSM_ATT_APB_LABOR_HOURSM_ATT_APB_LABOR_HOURSM_ATT_APB_LABOR_HOURSM_ATT_APB_LABOR_HOURSM_ATT_APB_LABOR_HOURSM_ATT_APB_LABOR_HOURSM_ATT_APB_LABOR_HOURSM_ATT_DOC_TYPE_SETSM_ATT_DOCUMENTSM_ATT_MILESTONESM_ATT_PPESM_ATT_PRICE_BREAKDOWNSM_ATT_PRICE_BREAKDOWNSM_ATT_PRICE_BREAKDOWNSM_ATT_PRICE_BREAKDOWNSM_ATT_PRICE_BREAKDOWNSM_ATT_PRICE_BREAKDOWNSM_ATT_PRICE_BREAKDOWNSM_ATT_PRICE_BREAKDOWNSM_ATT_RATE_TYPESM_ATT_SOW_MSM_ATT_SOW_MSM_ATT_SOW_MSM_ATT_SOW_MSM_ATT_SOW_MSM_ATT_SOW_MSM_ATT_SOW_MSM_ATT_SOW_MSM_ATT_SOW_MS_DETAILSM_ATT_SOW_MS_DETAILSM_ATT_SOW_MS_DETAILS
24Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
ASMSD_PKASMSD_PROJ_FKASMSD_UKAVCON_1227195475_ORDER_000ATNS_ATS_FKATNS_NLS_FKATNS_PKATS_DP_FKATS_PKATS_PROJ_FKATS_UKAVCON_1223911095_PK_TY_000AVCON_1224579416_PK_TY_000AVCON_1224579754_PK_TY_001AVCON_1226385820_DELET_000AVCON_1226385820_MANUA_000CITM_CSEC_FKCITM_PKCITM_PROJ_FKCITM_TD_FK1CITM_TD_FK10CITM_TD_FK2CITM_TD_FK3CITM_TD_FK4CITM_TD_FK5CITM_TD_FK6CITM_TD_FK7CITM_TD_FK8CITM_TD_FK9CITM_UK1CITM_UK2CATN_NLS_FKCATN_CAT_FKCATN_PKAVCON_1224090598_REV_S_000AVCON_1224090598_EXTRA_000CAT_PROJ_FKCAT_PKCAT_UKAVCON_1224090598_REVIS_000CSEC_AQC_FKCSEC_UKCSEC_PROJ_FKCSEC_PKCSEC_GN_FKCSEC_CAT_FKCEP_PKCEP_CSEC_FK
Table Name Constraint TypePRUCRRPRPRUCCCCCRPRRRRRRRRRRRUURRPCCRPUCRURPRRPR
M_ATT_SOW_MS_DETAILSM_ATT_SOW_MS_DETAILSM_ATT_SOW_MS_DETAILSM_ATT_SOW_MS_DETAILSM_ATT_SOW_NLSM_ATT_SOW_NLSM_ATT_SOW_NLSM_ATT_SOWSM_ATT_SOWSM_ATT_SOWSM_ATT_SOWSM_ATT_SOWSM_ATT_TERMSM_ATT_VDRSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_ITEMSM_CATALOG_NLSM_CATALOG_NLSM_CATALOG_NLSM_CATALOGSM_CATALOGSM_CATALOGSM_CATALOGSM_CATALOGSM_CATALOGSM_CATALOG_SECTIONSM_CATALOG_SECTIONSM_CATALOG_SECTIONSM_CATALOG_SECTIONSM_CATALOG_SECTIONSM_CATALOG_SECTIONSM_CATSEC_EXTRA_PRICESM_CATSEC_EXTRA_PRICES
25Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
CEP_CAT_FKCEP_PROJ_FKCEP_UKCSPN_UKCSPN_UNIT_FKCSPN_PKCSPN_CSEC_FKCSPN_PROJ_FKAVCON_1224142581_PRICE_000AVCON_1224142581_PRICE_001CTSD_UKCTSD_PROJ_FKCTSD_PKCTSD_CSEC_FKCTSD_TD_FKCTSG_PKCTSG_GN_FKCTSG_CSEC_FKAVCON_1223902462_SINGL_004AVCON_1223902462_SINGL_003AVCON_1223902462_SINGL_002AVCON_1223902462_SINGL_001AVCON_1223902462_SINGL_000CTSG_PROJ_FKC_CY_FKC_UK2CPRT_PLC_FKCPRT_UKCPRT_PK_BAKCSYM_CSYM2_UKDLS_DP_FKDLS_PKDLS_PROJ_FKDLS_UKDLSN_DLS_FKDLSN_NLS_FKDLSN_PKDVCN_DVC_FKDVCN_NLS_FKDVCN_PKDVC_PKDVC_UKECIB_UKECIB_SUP_FKECIB_PROJ_FKECIB_PKECIB_MG_FKECIB_ECI_FK
Table Name Constraint TypeRRUURPRRCCURPRRPRRCCCCCRRURUPURPRURRPRRPPUURRPRR
M_CATSEC_EXTRA_PRICESM_CATSEC_EXTRA_PRICESM_CATSEC_EXTRA_PRICESM_CAT_SEC_PRICE_NAMESM_CAT_SEC_PRICE_NAMESM_CAT_SEC_PRICE_NAMESM_CAT_SEC_PRICE_NAMESM_CAT_SEC_PRICE_NAMESM_CAT_SEC_PRICE_NAMESM_CAT_SEC_PRICE_NAMESM_CAT_SECTION_DETAILSM_CAT_SECTION_DETAILSM_CAT_SECTION_DETAILSM_CAT_SECTION_DETAILSM_CAT_SECTION_DETAILSM_CAT_SECTION_GEOMSM_CAT_SECTION_GEOMSM_CAT_SECTION_GEOMSM_CAT_SECTION_GEOMSM_CAT_SECTION_GEOMSM_CAT_SECTION_GEOMSM_CAT_SECTION_GEOMSM_CAT_SECTION_GEOMSM_CAT_SECTION_GEOMSM_COMPANIESM_COMPANIESM_COMPANY_PRICE_TYPESM_COMPANY_PRICE_TYPESM_COMPANY_PRICE_TYPES_BAKM_COMPANY_SYMBOLSM_DELV_STATUSM_DELV_STATUSM_DELV_STATUSM_DELV_STATUSM_DELV_STATUS_NLSM_DELV_STATUS_NLSM_DELV_STATUS_NLSM_DIVERSITY_CODE_NLSM_DIVERSITY_CODE_NLSM_DIVERSITY_CODE_NLSM_DIVERSITY_CODESM_DIVERSITY_CODESM_ENG_COMM_ITEM_BIDDERSM_ENG_COMM_ITEM_BIDDERSM_ENG_COMM_ITEM_BIDDERSM_ENG_COMM_ITEM_BIDDERSM_ENG_COMM_ITEM_BIDDERSM_ENG_COMM_ITEM_BIDDERS
26Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
ECIB_DP_FKECIN_NLS_FKECIN_PKECIN_ECI_FKECIR_FLS_FKECIR_PKECIR_PROJ_FKECIR_UKECIR_UK2ECIR_ECI_FKECIR_DP_FKAVCON_1220958660_ORDER_000ECI_PTY_FKECI_INQ_FKECI_GST_FKECI_CURRENCY_FKAVCON_1227213256_ORDER_003AVCON_1227213256_ORDER_002AVCON_1219320674_R_TYP_000AVCON_1226382232_PO_SU_001AVCON_1226382232_R_SUP_000AVCON_1220861285_LOGIS_000ECIS_ECI_FKECIS_ESP_FKECIS_EXP_ILV_FKECIS_DP_FKECIS_PKECIS_PROJ_FKECIS_SSY_FKECIS_UKECIS_INSP_ILV_FKAVCON_1226382371_PO_SU_000AVCON_1226382371_R_SUP_000EC_CPRT_FKEC_PK_BAKESP_PROJ_FKESP_PKESP_DP_FKESP_UKESPN_NLS_FKESPN_PKESPN_ESP_FKAVCON_1224579530_PK_TY_000AVCON_1224579783_PK_TY_000FTR_I_FKFTR_IVPR_FKFLSN_FLS_FKFLSN_PK
Table Name Constraint TypeRRPRRPRUURRCRRRRCCCCCCRRRRPRRURCCRPRPRURPRCCRRRP
M_ENG_COMM_ITEM_BIDDERSM_ENG_COMM_ITEM_NLSM_ENG_COMM_ITEM_NLSM_ENG_COMM_ITEM_NLSM_ENG_COMM_ITEM_RESPONSM_ENG_COMM_ITEM_RESPONSM_ENG_COMM_ITEM_RESPONSM_ENG_COMM_ITEM_RESPONSM_ENG_COMM_ITEM_RESPONSM_ENG_COMM_ITEM_RESPONSM_ENG_COMM_ITEM_RESPONSM_ENG_COMM_ITEM_RESPONSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEMSM_ENG_COMM_ITEM_STRATEGIESM_ENG_COMM_ITEM_STRATEGIESM_ENG_COMM_ITEM_STRATEGIESM_ENG_COMM_ITEM_STRATEGIESM_ENG_COMM_ITEM_STRATEGIESM_ENG_COMM_ITEM_STRATEGIESM_ENG_COMM_ITEM_STRATEGIESM_ENG_COMM_ITEM_STRATEGIESM_ENG_COMM_ITEM_STRATEGIESM_ENG_COMM_ITEM_STRATEGIESM_ENG_NON_COMM_ITEMSM_ENG_NON_COMM_ITEMSM_EST_CALCSM_EST_CALCS_BAKM_EVAL_SELECTION_PROCESSESM_EVAL_SELECTION_PROCESSESM_EVAL_SELECTION_PROCESSESM_EVAL_SELECTION_PROCESSESM_EVAL_SEL_PROCESS_NLSM_EVAL_SEL_PROCESS_NLSM_EVAL_SEL_PROCESS_NLSM_EXCEL_TEMPLATESM_FIND_CSSM_FORECAST_TRANS_RESULTSM_FORECAST_TRANS_RESULTSM_FUNCTION_LIST_NLSM_FUNCTION_LIST_NLS
27Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
FLSN_NLS_FKFLS_DP_FKFLS_UKFLS_PKFLS_PROJ_FKFSDS_UK2FSDS_UKFSDS_PROJ_FKFSDS_PKFSDS_DP_FKFSDS_FLS_FKFSDS_FST_FKAVCON_1229952160_ORDER_000FSTN_FST_FKFSTN_NLS_FKFSTN_PKFST_DP_FKFST_PKFST_PROJ_FKFST_UKGSTN_NLS_FKGSTN_GST_FKGSTN_PKGST_PROJ_FKGST_PKGST_DP_FKGST_UKHD_IVI_FKMICROSOFT_NN_VERSIONMICROSOFT_NN_PROPERTYMICROSOFT_NN_IDMICROSOFT_PK_DTPROPERTIESINQPA_PK_BAKAVCON_1220969492_ACCEP_000AVCON_1220969492_EVALU_000AVCON_1229513086_ORDER_001AVCON_1229513086_ORDER_000AVCON_1227533270_REQ_B_000AVCON_1226302750_I_SUP_000INQ_PTY_FKLB_PKAVCON_1225885408_ACTIV_000LB_USR_FKAVCON_1227623355_DEFAU_000LRC_UK2LRC_UKLRC_PKLRC_LRE_FK
Table Name Constraint TypeRRUPRUURPRRRCRRPRPRURRPRPRURCCCPPCCCCCCRPCRCUUPR
M_FUNCTION_LIST_NLSM_FUNCTION_LISTSM_FUNCTION_LISTSM_FUNCTION_LISTSM_FUNCTION_LISTSM_FUNCTION_SET_DETAILSM_FUNCTION_SET_DETAILSM_FUNCTION_SET_DETAILSM_FUNCTION_SET_DETAILSM_FUNCTION_SET_DETAILSM_FUNCTION_SET_DETAILSM_FUNCTION_SET_DETAILSM_FUNCTION_SET_DETAILSM_FUNCTION_SET_NLSM_FUNCTION_SET_NLSM_FUNCTION_SET_NLSM_FUNCTION_SETSM_FUNCTION_SETSM_FUNCTION_SETSM_FUNCTION_SETSM_GOOD_SERVICE_TYPE_NLSM_GOOD_SERVICE_TYPE_NLSM_GOOD_SERVICE_TYPE_NLSM_GOOD_SERVICE_TYPESM_GOOD_SERVICE_TYPESM_GOOD_SERVICE_TYPESM_GOOD_SERVICE_TYPESM_HEAT_DETAILSMICROSOFTDTPROPERTIESMICROSOFTDTPROPERTIESMICROSOFTDTPROPERTIESMICROSOFTDTPROPERTIESM_INQ_PAS_BAKM_INQ_SUPPLIERSM_INQ_SUPPLIERSM_INQUIRIESM_INQUIRIESM_INQUIRIESM_INQUIRIESM_INQUIRIESM_LOG_BROADCASTSM_LOG_BROADCASTSM_LOG_BROADCASTSM_LOGIN_REQUEST_CONTACTSM_LOGIN_REQUEST_CONTACTSM_LOGIN_REQUEST_CONTACTSM_LOGIN_REQUEST_CONTACTSM_LOGIN_REQUEST_CONTACTS
28Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
LRC_CCP_FKAVCON_1227871784_DEFAU_000LRE_CT_FKLRE_CTT_FKLRE_CY_FKLRE_UK2LRE_C_FKLRE_SUP_FKLRE_STPR_FKLRE_PKLRE_UKAVCON_1147427541_REVIS_000AVCON_1227691851_REVIS_001AVCON_1147427541_REVIS_031AVCON_1230551468_LRE_I_000AVCON_1230551468_LRE_I_001AVCON_1228123176_INCLU_001AVCON_1224584685_CHECK_000AVCON_1224077115_HUBZO_000AVCON_1224077115_OMOB__000OS_DVC_FKAVCON_1224077115_SDVOS_000AVCON_1224077115_VOSB__000AVCON_1224077115_WOSB__000OS_CT_FKAVCON_1224077115_BUSIN_000AVCON_1224077115_SDB_I_000AVCON_1228727100_C_SIG_000AVCON_1227213310_ORDER_001AVCON_1228727100_PERFO_000AVCON_1228727100_SC_SI_000AVCON_1229332340_PAYME_001POH_MG_FKPOH_PTY_FKAVCON_1228727100_PAYME_000AVCON_1227213310_ORDER_000AVCON_1225868882_REVIS_000AVCON_1225868882_PO_SU_000AVCON_1228312329_LAST__000AVCON_1228312329_FIRST_000PBM_UKPBM_PROJ_FKPBM_DP_FKPBM_PKAVCON_1224580001_PK_TY_000AVCON_1230629274_LOCK__000PLC_PROJ_FKPLC_SUP_FK
Table Name Constraint TypeRCRRRURRRPUCCCCCCCCCRCCCRCCCCCCCRRCCCCCCURRPCCRR
M_LOGIN_REQUEST_CONTACTSM_LOGIN_REQUEST_CONTACTSM_LOGIN_REQUESTSM_LOGIN_REQUESTSM_LOGIN_REQUESTSM_LOGIN_REQUESTSM_LOGIN_REQUESTSM_LOGIN_REQUESTSM_LOGIN_REQUESTSM_LOGIN_REQUESTSM_LOGIN_REQUESTSM_MATL_ISSUE_RPTSM_MATL_RECEIPTSM_MATL_RECV_RPTSM_MERGE_COMPANY_JOBSM_MERGE_COMPANY_JOBSM_MTO_TYPESM_OMI_IMPORT_JOBSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_OVERVIEW_SUPPLIERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_HEADERSM_PO_LINE_ITEMSM_PO_LINE_ITEMSM_PRE_BID_MEETINGSM_PRE_BID_MEETINGSM_PRE_BID_MEETINGSM_PRE_BID_MEETINGSM_PRE_BID_MEETINGSM_PRELIM_PACKAGESM_PRICE_LIST_CATALOGSM_PRICE_LIST_CATALOGS
29Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
PLC_UKPLC_CAT_FKPLC_PKAVCON_1223012083_REV_S_000PLI_PLC_FKPLI_CITM_FKPLI_PROJ_FKPLI_PKPNA_CSPN_FKAVCON_1223034834_MANDA_000PNA_PROJ_FKPNA_UK1PNA_UK2PNA_PKPNA_A_FKPR_PLI_FKPR_PK_BAKAVCON_1224158412_INCLU_000PTYN_PKPTYN_NLS_FKPTYN_PTY_FKPTY_PROJ_FKPTY_PKPTY_DP_FKPTY_UKAVCON_1224070483_CONFI_000QA_QR_FKQA_QE_FKQA_PKAVCON_1225883386_REV_L_000QA_UKAVCON_1227620738_ORDER_000AVCON_1227620738_QUALI_000QE_ATPL_FKQE_CT_FKQE_PKQE_UKQE_UK1AVCON_1227620738_MANDA_000AVCON_1227620738_LEVEL_000AVCON_1227620738_DOCUM_000AVCON_1227620738_ANSWE_000AVCON_1227620738_ACCEP_000AVCON_1227620738_ACTIV_000QMG_UKQMG_LRE_FKQMG_MG_FKQMG_PK
Table Name Constraint TypeURPCRRRPRCRUUPRRPCPRRRPRUCRRPCUCCRRPUUCCCCCCURRP
M_PRICE_LIST_CATALOGSM_PRICE_LIST_CATALOGSM_PRICE_LIST_CATALOGSM_PRICE_LIST_CATALOGSM_PRICE_LIST_ITEMSM_PRICE_LIST_ITEMSM_PRICE_LIST_ITEMSM_PRICE_LIST_ITEMSM_PRICE_NAME_ATTRSM_PRICE_NAME_ATTRSM_PRICE_NAME_ATTRSM_PRICE_NAME_ATTRSM_PRICE_NAME_ATTRSM_PRICE_NAME_ATTRSM_PRICE_NAME_ATTRSM_PRICESM_PRICES_BAKM_PRICE_TYPESM_PRICING_TYPE_NLSM_PRICING_TYPE_NLSM_PRICING_TYPE_NLSM_PRICING_TYPESM_PRICING_TYPESM_PRICING_TYPESM_PRICING_TYPESM_PROJECTSM_QUEST_ANSWERSM_QUEST_ANSWERSM_QUEST_ANSWERSM_QUEST_ANSWERSM_QUEST_ANSWERSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUESTIONSM_QUEST_MATERIAL_GROUPSM_QUEST_MATERIAL_GROUPSM_QUEST_MATERIAL_GROUPSM_QUEST_MATERIAL_GROUPS
30Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
AVCON_1224760604_LEVEL_000AVCON_1224760604_REV_000QR_LRE_FKQR_PKQR_UKAVCON_1228312408_FIRST_000AVCON_1228312408_LAST__000AVCON_1222182308_WILL__000AVCON_1228369976_SHIPP_000AVCON_1228369976_SHIPP_002AVCON_1227617159_RT_GR_000AVCON_1229078206_R_SUP_000RB_UKRB_SUP_FKRB_R_FKRB_PROJ_FKRB_PKRB_MG_FKRB_DP_FKAVCON_1225280339_R_TYP_000R_PTY_FKAVCON_1227691915_R_SUP_000AVCON_1227691915_REVIS_001AVCON_1227213206_ORDER_006AVCON_1227213206_ORDER_005AVCON_1229078366_R_SUP_000RFU_UNIT_FKAVCON_1212472891_MAR_U_000AVCON_1212472891_UNIT_000AVCON_1212472891_MAR_U_002AVCON_1212472891_UNIT_003AVCON_1212472892_UNIT_003AVCON_1212472892_MAR_U_000AVCON_1212472892_UNIT_001AVCON_1212472891_UNIT_002AVCON_1212472891_UNIT__001AVCON_1212472892_UNIT_002AVCON_1212472891_MAR_U_001AVCON_1212472891_UNIT_001AVCON_1212472892_UNIT_000AVCON_1212472891_UNIT__003SSY_DP_FKSSY_PKSSY_PROJ_FKSSY_UKSSYN_NLS_FKSSYN_PKSSYN_SSY_FK
Table Name Constraint TypeCCRPUCCCCCCCURRRPRRCRCCCCCRCCCCCCCCCCCCCCRPRURPR
M_QUEST_REVISIONSM_QUEST_REVISIONSM_QUEST_REVISIONSM_QUEST_REVISIONSM_QUEST_REVISIONSM_QUOTE_DETAILSM_QUOTE_DETAILSM_QUOTE_SUMMARIESM_QUOTE_SUMMARIESM_QUOTE_SUMMARIESM_RATE_TYPESM_REQ_BALANCE_REQSM_REQ_BIDDERSM_REQ_BIDDERSM_REQ_BIDDERSM_REQ_BIDDERSM_REQ_BIDDERSM_REQ_BIDDERSM_REQ_BIDDERSM_REQSM_REQSM_REQSM_REQSM_REQSM_REQSM_REQ_SETD_CASM_REQUEST_FOR_USERSM_SA_NODE_POSM_SA_NODE_POSM_SA_NODE_POS_DUPM_SA_NODE_POS_DUPM_SA_PF_IDENT_VALUESM_SA_PF_NODE_POSM_SA_PF_NODE_POSM_SA_PF_NODE_POS_VALUESM_SA_PF_NODE_VALUESM_SA_RF_IDENT_VALUESM_SA_RF_NODE_POSM_SA_RF_NODE_POSM_SA_RF_NODE_POS_VALUESM_SA_RF_NODE_VALUESM_SOURCING_STRATEGIESM_SOURCING_STRATEGIESM_SOURCING_STRATEGIESM_SOURCING_STRATEGIESM_SOURCING_STRATEGY_NLSM_SOURCING_STRATEGY_NLSM_SOURCING_STRATEGY_NLS
31Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
SOWD_PROJ_FKSOWD_SOW_FKSOWD_PKSOWD_UKSOWD_DP_FKSOWDN_NLS_FKSOWDN_PKSOWDN_SOWD_FKSOWN_PKSOWN_SOW_FKSOWN_NLS_FKSOW_DP_FKSOW_PKSOW_PROJ_FKSOW_UKAVCON_1226382894_PO_SU_000AVCON_1227213392_ORDER_000AVCON_1229078474_R_SUP_000SPWDCD_UKSPWDCD_DP_FKSPWDCD_PKSPWDCD_PROJ_FKSPWDCD_TD_FKSPWDCD_SPWPF_FKSPWDCD_SPWDC_FKSPWTID_SPWTI_FKSPWTID_D_FKSPWTID_PKSPWTID_PROJ_FKAVCON_1230903186_ROW_L_002AVCON_1230903186_MANUA_002AVCON_1230903186_ROW_A_002AVCON_1230903186_MANUA_003AVCON_1230903186_ROW_L_003AVCON_1230903186_ROW_A_003AVCON_1230903186_ROW_L_000AVCON_1230903186_ROW_A_000AVCON_1230903186_MANUA_000AVCON_1230903186_ROW_A_001AVCON_1230903186_MANUA_001AVCON_1230903186_ROW_L_001SP3D_IBJD_UK2SP3D_IBJD_UK1SP3D_IBJD_SP3D_IJ_FKSP3D_IBJD_SP3D_IBJ_FKSP3D_IBJD_PROJ_FKAVCON_1228916847_LOAD__000SP3D_IBJD_DP_FK
Table Name Constraint TypeRRPURRPRPRRRPRUCCCURPRRRRRRPRCCCCCCCCCCCCUURRRCR
M_SOW_DETAILSM_SOW_DETAILSM_SOW_DETAILSM_SOW_DETAILSM_SOW_DETAILSM_SOW_DETAILS_NLSM_SOW_DETAILS_NLSM_SOW_DETAILS_NLSM_SOW_NLSM_SOW_NLSM_SOW_NLSM_SOWSM_SOWSM_SOWSM_SOWSM_SPF_PO_PUBLISHESM_SPF_PO_PUBLISHESM_SPF_REQ_PUBLISHESM_SPW_DPM_CLASS_DETAILSM_SPW_DPM_CLASS_DETAILSM_SPW_DPM_CLASS_DETAILSM_SPW_DPM_CLASS_DETAILSM_SPW_DPM_CLASS_DETAILSM_SPW_DPM_CLASS_DETAILSM_SPW_DPM_CLASS_DETAILSM_SPW_TEMPLATE_ITEM_DETM_SPW_TEMPLATE_ITEM_DETM_SPW_TEMPLATE_ITEM_DETM_SPW_TEMPLATE_ITEM_DETM_SP3D_EXP_JOB_DTA_CCI_TMPM_SP3D_EXP_JOB_DTA_CCI_TMPM_SP3D_EXP_JOB_DTA_CCI_TMPM_SP3D_EXP_JOB_DTA_SI_TMPM_SP3D_EXP_JOB_DTA_SI_TMPM_SP3D_EXP_JOB_DTA_SI_TMPM_SP3D_EXP_JOB_DTA_SP_TMPM_SP3D_EXP_JOB_DTA_SP_TMPM_SP3D_EXP_JOB_DTA_SP_TMPM_SP3D_EXP_JOB_DTA_TMPM_SP3D_EXP_JOB_DTA_TMPM_SP3D_EXP_JOB_DTA_TMPM_SP3D_IMP_BATCH_JOB_DETAILSM_SP3D_IMP_BATCH_JOB_DETAILSM_SP3D_IMP_BATCH_JOB_DETAILSM_SP3D_IMP_BATCH_JOB_DETAILSM_SP3D_IMP_BATCH_JOB_DETAILSM_SP3D_IMP_BATCH_JOB_DETAILSM_SP3D_IMP_BATCH_JOB_DETAILS
32Page of
Database Changes Overview
40
Constraint Name
Constraints added: cont'd
SP3D_IBJD_PKSP3D_IBJ_PKSP3D_IBJ_PROJ_FKSP3D_IBJ_UKSP3D_IBJ_DP_FKSP3D_IMSAI_UKAVCON_1231150034_EXT_C_000ALREADY_APPROVED_CHECKAVCON_1223985423_HUBZO_000AVCON_1223985423_OMOB__000AVCON_1223985423_SDB_I_000AVCON_1223985423_BUSIN_000AVCON_1223985423_SDVOS_000SUP_DVC_FKAVCON_1223985423_VOSB__000AVCON_1223985423_WOSB__000AVCON_1226382960_PO_SU_000AVCON_1228304091_ORDER_000TDS_DP_FKTDS_GS_FKTDS_PKTDS_PROJ_FKTDS_TD_FKTDS_UKAVCON_1229078628_R_SUP_000TNPI_PKAVCON_1229078771_R_SUP_000AVCON_1225954037_TFD_S_000USR_UNIT_FKAVCON_1222167783_API_I_000PS_TXN_PK
Table Name Constraint TypePPRURUCCCCCCCRCCCCRRPRRUCPCCRCP
M_SP3D_IMP_BATCH_JOB_DETAILSM_SP3D_IMP_BATCH_JOBSM_SP3D_IMP_BATCH_JOBSM_SP3D_IMP_BATCH_JOBSM_SP3D_IMP_BATCH_JOBSM_SP3D_ITM_MAP_SHT_ATTR_IDTSM_SP3D_SHT_CONF_SHTSM_SUBSTITUTIONSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUPPLIERSM_SUP_PO_PERFSM_SUP_PO_PERFSM_TABLE_DETAIL_SCHEDULESM_TABLE_DETAIL_SCHEDULESM_TABLE_DETAIL_SCHEDULESM_TABLE_DETAIL_SCHEDULESM_TABLE_DETAIL_SCHEDULESM_TABLE_DETAIL_SCHEDULESM_TEMP_REQSM_TMP_NEW_PRJ_IDENTSM_TMP_REQSM_TRAFFIC_FREEZE_DETAILSM_USERSM_USER_SECURITIESPS_TXN
Trigger Name
Triggers removed:
M_COMP_AUR_TRG
M_COMP_TYPES_BUR_TRG
Table Name Trigger TypeBEFORE EACH ROW
BEFORE EACH ROW
M_COMPANIES
M_COMPANY_TYPES
Trigger Name
Triggers added:
ACS_INSERT_JOB_ID
M_ALH_TRG
Table Name Trigger TypeBEFORE EACH ROW
BEFORE EACH ROW
M_JOBS
M_ATT_APB_LABOR_HOURS
33Page of
Database Changes Overview
40
Trigger Name
Triggers added: cont'd
M_ALT_OPTIONS_TRG
M_APPROVAL_USER_REPRS_TRG
M_APPROVAL_USERS_PROJ_TRG
M_ATT_ADDENDAS_TRG
M_ATT_PRICE_BREAKDOWNS_TRG
M_ATT_SOW_MS_DETAILS_TRG
M_ATT_SOW_MS_TRG
M_ATT_SOW_NLS_TRG
M_ATT_SOWS_TRG
M_AUR_BIR_TRG
M_AUR_BUR_TRG
M_CA_AUDR_TRG
M_CATALOG_ITEMS_TRG
M_CATALOG_NLS_TRG
M_CATALOG_SECTIONS_TRG
M_CATALOGS_TRG
M_CATSEC_EXTRA_PRICES_TRG
M_CAT_SEC_PRICE_NAMES_TRG
M_CAT_SECTION_DETAILS_TRG
M_CAT_SECTION_GEOMS_TRG
M_CML_ADR_TRG
M_COMP_AUR_TRG
M_COMP_BUDR_TRG
M_COMP_TYPE_BUDR_TRG
M_CTT_AIS_TRG
M_DELV_STATUS_NLS_TRG
M_DELV_STATUS_TRG
M_DIVERSITY_CODE_NLS_TRG
M_DIVERSITY_CODES_TRG
M_ENG_COMM_ITEM_BIDDERS_TRG
M_ENG_COMM_ITEM_NLS_TRG
M_ENG_COMM_ITEM_RESPONS_TRG
M_ENG_COMM_ITEM_STRATEGIES_TRG
M_EVAL_SELECTION_PROCESSES_TRG
M_EVAL_SELECTION_PROC_NLS_TRG
M_FUNCTION_LIST_NLS_TRG
M_FUNCTION_LISTS_TRG
M_FUNCTION_SET_DETAILS_TRG
M_FUNCTION_SET_NLS_TRG
M_FUNCTION_SETS_TRG
Table Name Trigger TypeBEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
AFTER EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
AFTER EACH ROW
AFTER EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
AFTER STATEMENT
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
M_ALT_OPTIONS
M_APPROVAL_USER_REPRS
M_APPROVAL_USERS
M_ATT_ADDENDAS
M_ATT_PRICE_BREAKDOWNS
M_ATT_SOW_MS_DETAILS
M_ATT_SOW_MS
M_ATT_SOW_NLS
M_ATT_SOWS
M_APPROVAL_USER_REPRS
M_APPROVAL_USER_REPRS
M_COMPANY_ADDRS
M_CATALOG_ITEMS
M_CATALOG_NLS
M_CATALOG_SECTIONS
M_CATALOGS
M_CATSEC_EXTRA_PRICES
M_CAT_SEC_PRICE_NAMES
M_CAT_SECTION_DETAILS
M_CAT_SECTION_GEOMS
M_COMMUNICATION_LINKS
M_COMPANIES
M_COMPANIES
M_COMPANY_TYPES
M_COMPANY_TO_TYPES
M_DELV_STATUS_NLS
M_DELV_STATUS
M_DIVERSITY_CODE_NLS
M_DIVERSITY_CODES
M_ENG_COMM_ITEM_BIDDERS
M_ENG_COMM_ITEM_NLS
M_ENG_COMM_ITEM_RESPONS
M_ENG_COMM_ITEM_STRATEGIES
M_EVAL_SELECTION_PROCESSES
M_EVAL_SEL_PROCESS_NLS
M_FUNCTION_LIST_NLS
M_FUNCTION_LISTS
M_FUNCTION_SET_DETAILS
M_FUNCTION_SET_NLS
M_FUNCTION_SETS
34Page of
Database Changes Overview
40
Trigger Name
Triggers added: cont'd
M_GOOD_SERVICE_TYPES_TRG
M_GOOD_SERVICE_TYP_NLS_TRG
M_LOG_BROADCASTS_TRG
M_LOGIN_REQUEST_CONTACT_TRG
M_LOGIN_REQUESTS_AUR_TRG
M_LOGIN_REQUESTS_TRG
M_LRC_AIUDR_TRG
M_LRC_AIU_TRG
M_MIR_ADS
M_MIR_BDS
M_PRE_BID_MEETINGS_TRG
M_PRICE_LIST_CATALOGS_TRG
M_PRICE_LIST_ITEMS_TRG
M_PRICE_NAME_ATTRS_TRG
M_PRICING_TYPE_NLS_TRG
M_PRICING_TYPES_TRG
M_QUEST_ANSWERS_TRG
M_QUESTIONS_AIUS_TRG
M_QUESTIONS_TRG
M_QUEST_MATERIAL_GROUPS_TRG
M_QUEST_REVISIONS_TRG
M_REQ_BIDDERS_TRG
M_SHOW_DETAILS_NLS_TRG
M_SOURCING_STRATEGIES_TRG
M_SOURCING_STRATEGY_NLS_TRG
M_SOW_DETAILS_TRG
M_SOW_NLS_TRG
M_SOWS_TRG
M_SPW_DPM_CLASS_DETAILS_TRG
M_SPW_TEMPLATES_ITEM_DET_TRG
M_TABLE_DETAIL_SCHEDULES_TRG
M_TMP_NEW_PRJ_IDENTS_TRG
MV_DBA_CIPS_D_TRG
MVP_SP3D_IMP_BATCH_JOB_DET_TRG
MVP_SP3D_IMP_BATCH_JOBS_TRG
Table Name Trigger TypeBEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
AFTER EACH ROW
BEFORE EACH ROW
AFTER EACH ROW
AFTER STATEMENT
AFTER STATEMENT
BEFORE STATEMENT
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
AFTER STATEMENT
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
BEFORE EACH ROW
INSTEAD OF
BEFORE EACH ROW
BEFORE EACH ROW
M_GOOD_SERVICE_TYPES
M_GOOD_SERVICE_TYPE_NLS
M_LOG_BROADCASTS
M_LOGIN_REQUEST_CONTACTS
M_LOGIN_REQUESTS
M_LOGIN_REQUESTS
M_LOGIN_REQUEST_CONTACTS
M_LOGIN_REQUEST_CONTACTS
M_MATL_ISSUE_RPTS
M_MATL_ISSUE_RPTS
M_PRE_BID_MEETINGS
M_PRICE_LIST_CATALOGS
M_PRICE_LIST_ITEMS
M_PRICE_NAME_ATTRS
M_PRICING_TYPE_NLS
M_PRICING_TYPES
M_QUEST_ANSWERS
M_QUESTIONS
M_QUESTIONS
M_QUEST_MATERIAL_GROUPS
M_QUEST_REVISIONS
M_REQ_BIDDERS
M_SOW_DETAILS_NLS
M_SOURCING_STRATEGIES
M_SOURCING_STRATEGY_NLS
M_SOW_DETAILS
M_SOW_NLS
M_SOWS
M_SPW_DPM_CLASS_DETAILS
M_SPW_TEMPLATE_ITEM_DET
M_TABLE_DETAIL_SCHEDULES
M_TMP_NEW_PRJ_IDENTS
MV_DBA_CIPS
M_SP3D_IMP_BATCH_JOB_DETAILS
M_SP3D_IMP_BATCH_JOBS
Package Name
Parameters added in CIP function:
M_PCK_COMPANY_CUSTOM
Object Name IN/OUTINCHECK_COMPANY_PROF
Argument NameP_LRE_ID
Data TypeNUMBER
35Page of
Database Changes Overview
40
Package Name
Parameters added in CIP function: cont'd
M_PCK_COMPANY_CUSTOM
M_PCK_COMPANY_CUSTOM
M_PCK_COMPANY_CUSTOM
M_PCK_COMPANY_CUSTOM
M_PCK_COMPANY_CUSTOM
M_PCK_COMPANY_CUSTOM
M_PCK_COMPANY_CUSTOM
M_PCK_COMPANY_CUSTOMM_PCK_COMPANY_CUSTOMM_PCK_COMPANY_CUSTOM
M_PCK_COMPANY_CUSTOMM_PCK_COMPANY_CUSTOMM_PCK_COMPANY_CUSTOMM_PCK_COMPANY_CUSTOMM_PCK_INTOOLS_CUSTOMM_PCK_INTOOLS_CUSTOMM_PCK_ISKETCH_CUSTOMM_PCK_OMI_CUSTOMM_PCK_OMI_CUSTOMM_PCK_OMI_CUSTOMM_PCK_OMI_CUSTOMM_PCK_OMI_CUSTOMM_PCK_OMI_CUSTOMM_PCK_PDS_CUSTOM
M_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOM
Object Name IN/OUT
IN
IN
IN
IN
IN
IN
IN
INININ
ININININININININOUTOUTOUTOUTOUTIN
INININININININININININININININININININININININ
ILE_APPROVALCHECK_COMPANY_PROFILE_APPROVALCHECK_COMPANY_PROFILE_APPROVALCHECK_COMPANY_PROFILE_APPROVALCHECK_LOGIN_APPROVALCHECK_LOGIN_APPROVALCHECK_LOGIN_APPROVALCHECK_LOGIN_APPROVALGET_CLIENT_USER_IDGET_CLIENT_USER_IDLOGIN_REQUEST_INFORMATION_TEXTNEW_USER_EMAIL_TEXTNEW_USER_EMAIL_TEXTNEW_USER_EMAIL_TEXTNEW_USER_EMAIL_TEXTADD_ATTRSADD_ATTRSGENERAL_CIPCHECK_CONSISTENCYVERSIONVERSIONVERSIONVERSIONVERSIONAFTER_PDL_GENERATIONGET_PDLH_CCGET_PDLH_CCGET_PDLH_CCGET_PDLH_ENDPRPGET_PDLH_ENDPRPGET_PDLH_ENDPRPGET_PDLH_ENDPRPGET_PDLH_ENDPRPGET_PDLH_GEOSTDGET_PDLH_GEOSTDGET_PDLH_GEOSTDGET_PDLH_GEOSTDGET_PDLH_GEOSTDGET_PDLH_GEOSTDGET_PDLH_GEOSTDGET_PDLH_MATERIALGET_PDLH_MATERIALGET_PDLH_MATERIALGET_PDLH_MATERIALGET_PDLH_MATERIALGET_PDLH_MODELGET_PDLH_MODELGET_PDLH_MODEL
Argument Name
P_M_USR_ID
P_APPROVED_IND
P_REJECTED_IND
P_LRE_ID
P_USR_ID
P_APPROVED_IND
P_REJECTED_IND
P_USER_IDP_COMPANY_CODEP_LRE_ID
P_LRE_IDP_LRC_IDP_CLIENT_USER_IDP_PASSWORDP_TAGNUMBERP_SHORT_CODEP_ISEJ_IDP_OMIJ_IDVERSIONBUILDLMODNAMETEXTP_PDS_PDL_JOB_NUMBER
P_PDLM_IDP_SPEC_ITEM_IDP_COMMODITY_IDP_PDLM_IDP_SPEC_ITEM_IDP_COMMODITY_IDP_1_OR_2P_INTERFACE_IDP_PDLM_IDP_SPEC_ITEM_IDP_COMMODITY_IDP_CL575_TRANSLP_CL575_METHODP_CL575_STARTP_INTERFACE_IDP_PDLM_IDP_SPEC_ITEM_IDP_COMMODITY_IDP_MODEL_METHODP_CL145_TRANSLP_PDLM_IDP_SPEC_ITEM_IDP_COMMODITY_ID
Data Type
VARCHAR2
VARCHAR2
VARCHAR2
NUMBER
VARCHAR2
VARCHAR2
VARCHAR2
VARCHAR2VARCHAR2NUMBER
NUMBERNUMBERVARCHAR2VARCHAR2VARCHAR2VARCHAR2NUMBERNUMBERVARCHAR2VARCHAR2DATEVARCHAR2VARCHAR2VARCHAR2
NUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERVARCHAR2NUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERVARCHAR2NUMBERNUMBERNUMBER
36Page of
Database Changes Overview
40
Package Name
Parameters added in CIP function: cont'd
M_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PDS_CUSTOMM_PCK_PO_CUSTOMM_PCK_QUOTE_CUSTOMM_PCK_REQ_CUSTOMM_PCK_REQ_CUSTOMM_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
Object Name IN/OUTINININININININININININININININININININININININININININININININININININININININININ
IN
IN
IN
IN
IN
IN
IN
IN
GET_PDLH_MODELGET_PDLH_MODELGET_PDLH_MODELGET_PDLH_MODIFGET_PDLH_MODIFGET_PDLH_MODIFGET_PDLH_MODIFGET_PDLH_MODIFGET_PDLH_RATINGGET_PDLH_RATINGGET_PDLH_RATINGGET_PDLH_RATINGGET_PDLH_RATINGGET_PDLH_RATINGGET_PDLH_SCHEDULEGET_PDLH_SCHEDULEGET_PDLH_SCHEDULEGET_PDLH_SCHEDULEGET_PDLH_SCHEDULEGET_PDLH_SCHEDULEGET_PDLH_SCHEDULEGET_PDLH_TSGET_PDLH_TSGET_PDLH_TSGET_PDLH_TSGET_PDLH_TSGET_PDLH_TSGET_PDLH_TSGET_PDLH_TSGET_PDLH_TSGET_PDLH_WCGET_PDLH_WCGET_PDLH_WCGET_PDLH_WCGET_PDLH_WCGET_PDLH_WCIMPORT_PB_ITEMS_CIPIMPORT_PB_ITEMS_CIPALLOW_REQ_DELETIONIMPORT_PB_ITEMS_CIPSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QT
Argument NameP_MODEL_METHODP_PART_IDP_INTERFACE_IDP_PDLM_IDP_SPEC_ITEM_IDP_COMMODITY_IDP_CL550_TRANSLP_INTERFACE_IDP_PDLM_IDP_SPEC_ITEM_IDP_COMMODITY_IDP_RAT_TRANSL1P_RAT_TRANSL2P_INTERFACE_IDP_PDLM_IDP_SPEC_ITEM_IDP_COMMODITY_IDP_SCHEDULE_METHODP_1_OR_2P_INTERFACE_IDP_INPUT_SCHEDULEP_PDLM_IDP_SPEC_ITEM_IDP_COMMODITY_IDP_TS_METHODP_TS_TRANSLP_1_OR_2P_CL576_STARTP_CL577_STARTP_INTERFACE_IDP_PDLM_IDP_SPEC_ITEM_IDP_COMMODITY_IDP_CL578_METHODP_WC_SOURCEP_INTERFACE_IDP_POH_IDP_INQ_IDP_R_IDP_R_IDP_QTY
P_VALUE1
P_VALUE2
P_VALUE3
P_MIN_ADDEND
P_MAX_ADDEND
P_CHAR1
P_CHAR2
P_CHAR3
Data TypeNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERVARCHAR2NUMBERNUMBERNUMBERNUMBERVARCHAR2VARCHAR2NUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERVARCHAR2NUMBERNUMBERNUMBERNUMBERVARCHAR2NUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBERVARCHAR2NUMBERNUMBERNUMBERNUMBERNUMBERNUMBERNUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR2
VARCHAR2
VARCHAR2
37Page of
Database Changes Overview
40
Package Name
Parameters added in CIP function: cont'd
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOM
M_PCK_REQ_CUSTOMM_PCK_SITE_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOM
Object Name IN/OUT
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
IN
INININININININININININININININ
YSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_GLOBAL_DISPO_QTYSTD_JOB_IDBEFORE_POST_MIRCONVERT_PHY_DIMCONVERT_PHY_DIMCONVERT_PHY_DIMCONVERT_SIZECONVERT_SIZECONVERT_SIZEGET_EXP_WBK_NAMEGET_EXP_WBK_NAMEGET_GN_CONVERTEDGET_GN_CONVERTEDGET_GN_CONVERTEDGET_TD_ENDPREPGET_TD_RATING
Argument Name
P_CHAR4
P_CHAR5
P_NUM1
P_NUM2
P_NUM3
P_NUM4
P_NUM5
P_IDENT
P_TAG_NUMBER
P_ITY_ID
P_QTY_UNIT_ID
P_ATTR_GROUP1
P_ATTR_GROUP2
P_ATTR_GROUP3
P_ATTR_GROUP4
P_ATTR_GROUP5
P_ATTR_SUM1
P_ATTR_SUM2
P_ATTR_SUM3
P_RECOMMEND_QTY
P_CALL_FOR
P_CALLP_MIR_IDP_GN_IDP_PHYSICAL_ATTRIBUTEP_INPUTP_INPUTP_INPUT_UNITP_OUTPUT_UNITP_EJ_IDP_CATEGORYP_GN_IDP_PHYSICAL_ATTRIBUTEP_INPUTP_COMMODITY_IDP_COMMODITY_ID
Data Type
VARCHAR2
VARCHAR2
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR2
NUMBER
NUMBER
VARCHAR2
VARCHAR2
VARCHAR2
VARCHAR2
VARCHAR2
NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR2
VARCHAR2NUMBERNUMBERVARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2NUMBERVARCHAR2NUMBERVARCHAR2VARCHAR2NUMBERNUMBER
38Page of
Database Changes Overview
40
Package Name
Parameters changed in CIP function:
M_PCK_FORECAST_CUSTOMM_PCK_FORECAST_CUSTOMM_PCK_INTOOLS_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_SP3D_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOM
Object Name IN/OUTIN
IN
INININININ
WEIGHT
WEIGHT
ADD_ATTRSGET_IDENT_VALUEGET_IDENT_VALUEGET_PROJ_IDGET_PROJ_ID
Argument NameP_IVPR_ID
P_WPTF_ID
P_TAGNUMBERP_INTERFACE_CODEP_KIND_OF_ATTRP_COMMODITY_IDP_SPEC_ITEM_ID
Data TypeNUMBER
NUMBER
VARCHAR2VARCHAR2VARCHAR2NUMBERNUMBER
Packages added:
Packages Name Object TypeM_PCK_ALT_OPTM_PCK_ALT_OPTM_PCK_APPROVED_USER_REPRSM_PCK_APPROVED_USER_REPRS
PACKAGEPACKAGE BODYPACKAGEPACKAGE BODY
Package Name
Parameters added in CIP function: cont'd
M_PCK_SP3D_CUSTOM
M_PCK_SP3D_CUSTOM
M_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOMM_PCK_STD_CUSTOM
Object Name IN/OUTIN
IN
ININININININININININININININININININININININININININININ
POST_PROCESS_FLTR_GEOMPOST_PROCESS_SHT_DATACHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCHECK_INV_IDENTSCODE_BLD_CIPGET_IDENT_NLS_TRANSGET_IDENT_NLS_TRANSNEW_IDENT_CODENEW_RB_IDENT_CODE
Argument NameP_GN_ID
P_IJSHT_ID
P_COMMODITY_IDP_USY_IDP_IN1P_IN2P_IN3P_IN4P_IN5P_OUT1P_OUT2P_OUT3P_OUT4P_OUT5P_OUT6P_OUT7P_OUT8P_OUT9P_OUT10P_OUT11P_OUT12P_OUT13P_OUT14P_OUT15P_PROJ_IDP_COMMODITY_IDP_IDENTP_NLS_IDP_USY_IDP_USY_ID
Data TypeNUMBER
NUMBER
NUMBERNUMBERVARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2VARCHAR2NUMBERNUMBERNUMBERNUMBERNUMBER
39Page of
Database Changes Overview
40
Packages added: cont'd
Packages Name Object TypeM_PCK_APRV_SEQM_PCK_APRV_SEQM_PCK_AUTHIDM_PCK_AUTHIDM_PCK_PD_ZOM_PCK_PD_ZOM_PCK_PRICE_BRKDWNM_PCK_PRICE_BRKDWNM_PCK_PRICE_LISTSM_PCK_PRICE_LISTSM_PCK_SUBCONTRM_PCK_SUBCONTR
PACKAGEPACKAGE BODYPACKAGEPACKAGE BODYPACKAGEPACKAGE BODYPACKAGEPACKAGE BODYPACKAGEPACKAGE BODYPACKAGEPACKAGE BODY
New Reports:
Menu ItemR30R03
Obsolete Reports:
Menu ItemC20R27
New Parameters:ParameterO_ITEMS
O_SPEC_CDO_SPEC_TYP
P_AUTHORP_CHREASONP_COM_C
Lexicallexikal Order-By-Clause
lexikal Order-By-Clauselexikal Order-By-Clause
no lexical parameterno lexical parameterno lexical parameter
Parm TypeAdmin MARIAN
Admin MARIANAdmin MARIAN
Product (MARIAN) wida valiProduct (MARIAN) wida valiAdmin MARIAN
Query TypeStatic
NoneStatic
NoneNoneQuery
Data TypeCharacter
CharacterCharacter
CharacterCharacterCharacter
Parameter Value
Parameter Value
Comment
Comment
Default
Default
commodity_codeoption_codepart_codeshort_code
spec_rule_idspec_typesp_id
NNNN
NNN
Obsolete Parameters:
ParameterP_BOM_COMMP_COMMENT
40Page of
Database Changes Overview
40
New Parameters:Parameter
P_FSIZE1P_L_ID
P_PO_POS
P_RELEASEP_VERSION
Lexical
no lexical parameterno lexical parameter
no lexical parameter
no lexical parameterno lexical parameter
Parm Type
Admin MARIANProduct (MARIAN) wida vali
Admin MARIAN
Product (MARIAN) wida valiProduct (MARIAN) wida vali
Query Type
QueryQuery
Query
NoneNone
Data Type
CharacterCharacter
Character
CharacterCharacter
LOV Command:
LOV Command:
LOV Command:
SELECT cc.commodity_code , ccnls.short_desc FROM m_commodity_codes cc, m_commodity_code_nlsccnlsWHERE ccnls.commodity_id = cc.commodity_id AND ccnls.nls_id = :CTRL.NLS_IDUNION ALL SELECT cc.commodity_code , to_char(NULL) FROM m_commodity_codes ccwhere not exists (select 1 from m_commodity_code_nls ccnwhere cc.commodity_id = ccn.commodity_idand ccn.nls_id = :ctrl.nls_id) order by 1/* S.30.01 Commodity Codes */
Select L_ID , L_CODE from M_LAYOUTS order by L_ID/* A.20.09 Project Report Layout */
Select distinct to_char(ph.POH_ID) , ph.PO_NUMBER || ' Supp: ' || ph.PO_SUPP po_number fromM_PO_HEADERS ph, m_po_line_items pli, m_item_ships ish, m_osds osd where ph.poh_id = pli.poh_idand pli.poli_id = ish.poli_id and ish.item_ship_id = osd.item_ship_id union Select '%' , 'All POs' po_numberfrom m_po_headers order by 2 /* P.50.11 Maintain PO */