You are browsing the archive for OPM.

Oracle Process Manufacturing Product Development Tables

OPM Product Development

  • GMD_ACTIONS_B
  • GMD_ACTIONS_TL
  • GMD_ACTIVITIES_B
  • GMD_ACTIVITIES_TL
  • GMD_CHANGE_DISPOSITION
  • GMD_CHANGE_LOTS
  • GMD_COA_DETAILS
  • GMD_COA_HEADERS
  • GMD_COA_RSLT_TEXT
  • GMD_COA_SPEC_HDR_TEXT
  • GMD_COA_SPEC_TEXT
  • GMD_COMPOSITE_RESULTS
  • GMD_COMPOSITE_RESULT_ASSOC
  • GMD_COMPOSITE_SPEC_DISP
  • GMD_COMPOSITIONAL_REQS
  • GMD_CUSTOMER_SPEC_VRS
  • GMD_CUSTOMER_TESTS_B
  • GMD_CUSTOMER_TESTS_TL
  • GMD_EVENT_SPEC_DISP
  • GMD_FORMULATION_SPECS
  • GMD_FORMULA_ANALYSIS_DTL
  • GMD_FORMULA_ANALYSIS_HDR
  • GMD_FORMULA_CLASS_B
  • GMD_FORMULA_CLASS_TL
  • GMD_FORMULA_SECURITY
  • GMD_FORMULA_SECURITY_TEMP
  • GMD_FORMULA_SUBSTITUTION
  • GMD_GRADES_B
  • GMD_GRADES_TL
  • GMD_HOLD_REASONS_B
  • GMD_HOLD_REASONS_TL
  • GMD_INVENTORY_SPEC_VRS
  • GMD_ITEM_SUBSTITUTION_DTL
  • GMD_ITEM_SUBSTITUTION_HDR_B
  • GMD_ITEM_SUBSTITUTION_HDR_TL
  • GMD_LAB_FORMULA_ASSOC
  • GMD_LAB_ORGN_ASSOC
  • GMD_LCF_CATEGORY_DTL_GTMP
  • GMD_LCF_CATEGORY_HDR_GTMP
  • GMD_LCF_DETAILS_GTMP
  • GMD_LCF_EXTERNAL_COST
  • GMD_LCF_TECH_DATA_GTMP
  • GMD_MASS_RESULTS_GT
  • GMD_MASS_SAMPLES
  • GMD_MATERIAL_DETAILS_GTMP
  • GMD_MATERIAL_HEADER_GTMP
  • GMD_MATERIAL_REQS
  • GMD_MIGRATE_PARMS
  • GMD_MIGRATION
  • GMD_MONITORING_SPEC_VRS
  • GMD_MSNR_RESULTS
  • GMD_OPERATIONS_B
  • GMD_OPERATIONS_TL
  • GMD_OPERATION_ACTIVITIES
  • GMD_OPERATION_CLASS_B
  • GMD_OPERATION_CLASS_TL
  • GMD_OPERATION_RESOURCES
  • GMD_OPRN_PROCESS_PARAMETERS
  • GMD_OPTIMIZER_HDR_GTMP
  • GMD_OPTIMIZER_LINE_GTMP
  • GMD_PARAMETERS
  • GMD_PARAMETERS_DTL
  • GMD_PARAMETERS_HDR
  • GMD_PARSED_EXPRESSION
  • GMD_PROCESS_LOSS
  • GMD_QC_ASSAY_CLASS
  • GMD_QC_SPEC_MST_GTMP
  • GMD_QC_STATUS_B
  • GMD_QC_STATUS_NEXT
  • GMD_QC_STATUS_TL
  • GMD_QC_TESTS_B
  • GMD_QC_TESTS_TL
  • GMD_QC_TEST_VALUES_B
  • GMD_QC_TEST_VALUES_TL
  • GMD_QUALITY_CONFIG
  • GMD_RECIPES_B
  • GMD_RECIPES_TL
  • GMD_RECIPE_CUSTOMERS
  • GMD_RECIPE_EFF_ASSOC
  • GMD_RECIPE_GENERATION
  • GMD_RECIPE_ORGN_ACTIVITIES
  • GMD_RECIPE_ORGN_RESOURCES
  • GMD_RECIPE_PROCESS_LOSS
  • GMD_RECIPE_PROCESS_PARAMETERS
  • GMD_RECIPE_ROUTING_STEPS
  • GMD_RECIPE_STEP_MATERIALS
  • GMD_RECIPE_VALIDITY_RULES
  • GMD_REPLACE
  • GMD_RESULTS
  • GMD_ROUTINGS_B
  • GMD_ROUTINGS_TL
  • GMD_ROUTING_CLASS_B
  • GMD_ROUTING_CLASS_TL
  • GMD_SAMPLES
  • GMD_SAMPLES_LAB
  • GMD_SAMPLE_REPLICATES_GT
  • GMD_SAMPLE_SPEC_DISP
  • GMD_SAMPLING_EVENTS
  • GMD_SAMPLING_PLANS_B
  • GMD_SAMPLING_PLANS_TL
  • GMD_SECURITY_CONTROL
  • GMD_SECURITY_PROFILES
  • GMD_SPECIFICATIONS_B
  • GMD_SPECIFICATIONS_TL
  • GMD_SPECIFICATION_ATTRIBUTES
  • GMD_SPEC_MAPPING
  • GMD_SPEC_MAPPING_GTMP
  • GMD_SPEC_RESULTS
  • GMD_SPEC_TESTS_B
  • GMD_SPEC_TESTS_TL
  • GMD_SPREAD_ERRORS_GTMP
  • GMD_SS_MATERIAL_SOURCES
  • GMD_SS_STORAGE_HISTORY
  • GMD_SS_STORAGE_PACKAGE
  • GMD_SS_TIME_POINTS
  • GMD_SS_VARIANTS
  • GMD_STABILITY_SPEC_VRS
  • GMD_STABILITY_STUDIES_B
  • GMD_STABILITY_STUDIES_TL
  • GMD_STATUS_B
  • GMD_STATUS_NEXT
  • GMD_STATUS_TL
  • GMD_STORAGE_PLANS_B
  • GMD_STORAGE_PLANS_TL
  • GMD_STORAGE_PLAN_DETAILS
  • GMD_SUPPLIER_SPEC_VRS
  • GMD_TECHNICAL_DATA_DTL
  • GMD_TECHNICAL_DATA_HDR
  • GMD_TECHNICAL_REQS
  • GMD_TECHNICAL_SEQUENCE_DTL
  • GMD_TECHNICAL_SEQUENCE_HDR
  • GMD_TECH_PARAMETERS_B
  • GMD_TECH_PARAMETERS_TL
  • GMD_TESTS_B
  • GMD_TESTS_TL
  • GMD_TEST_CLASSES_B
  • GMD_TEST_CLASSES_TL
  • GMD_TEST_GROUP_GT
  • GMD_TEST_INTERVAL_PLANS_B
  • GMD_TEST_INTERVAL_PLANS_TL
  • GMD_TEST_INTERVAL_PLAN_PERIODS
  • GMD_TEST_METHODS_B
  • GMD_TEST_METHODS_TL
  • GMD_TEST_VALUES_B
  • GMD_TEST_VALUES_TL
  • GMD_UNITS_B
  • GMD_UNITS_TL
  • GMD_UOM_CONVERSIONS
  • GMD_VAL_RULE_GTMP
  • GMD_VPD_SECURITY
  • GMD_WIP_SPEC_VRS

Oracle Process Manufacturing Inventory Tables

Oracle Process Manufacturing Inventory – List of database tables

  • BISOPM_ONHANDSALE_SUM
  • BIS_OPM_PROD_SUM
  • GMI_AUTO_ALLOCATION_BATCH
  • GMI_CATEGORY_SETS
  • GMI_CLOS_WAREHOUSES
  • GMI_DISCRETE_TRANSFERS
  • GMI_DISCRETE_TRANSFER_LINES
  • GMI_DISCRETE_TRANSFER_LOTS
  • GMI_ITEMS_XML_INTERFACE
  • GMI_ITEM_CATEGORIES
  • GMI_ITEM_CONV_AUDIT
  • GMI_ITEM_CONV_AUDIT_DETAILS
  • GMI_ITEM_ORGANIZATIONS
  • GMI_LOTS_CONV_XML_INTERFACE
  • GMI_LOTS_XML_INTERFACE
  • GMI_LOT_TRACE
  • GMI_MASSTRANS_CTL
  • GMI_MIGRATION_PARAMETERS
  • GMI_OBSOLETE_ITEM_COLUMNS
  • GMI_QUANTITY_XML_INTERFACE
  • GMI_SUBLOT_GENERATE
  • GMI_TRAN_TMP
  • IC_ADJS_JNL
  • IC_ALLC_CLS
  • IC_ALOT_PRM
  • IC_CLDR_DTL
  • IC_CLDR_HDR
  • IC_CLDR_HDR_B
  • IC_CLDR_HDR_TL
  • IC_COMD_CDS
  • IC_COST_CLS
  • IC_CRUL_CLS
  • IC_CTMS_CLS
  • IC_CYCL_ADT
  • IC_CYCL_DTL
  • IC_CYCL_ERR
  • IC_CYCL_HDR
  • IC_CYCL_MSC
  • IC_DECM_MST
  • IC_FRGT_CLS
  • IC_GLED_CLS
  • IC_INVN_CLS
  • IC_INVN_TYP
  • IC_ITEM_CDT
  • IC_ITEM_CNV
  • IC_ITEM_CPG
  • IC_ITEM_HIERARCHY
  • IC_ITEM_MST
  • IC_ITEM_MST_B
  • IC_ITEM_MST_B_MIG
  • IC_ITEM_MST_TL
  • IC_ITEM_WHS
  • IC_JRNL_MST
  • IC_LOCT_INV
  • IC_LOCT_MST
  • IC_LOTS_CPG
  • IC_LOTS_MST
  • IC_LOTS_MST_MIG
  • IC_LOTS_STS
  • IC_PERD_BAL
  • IC_PHYS_CNT
  • IC_PHYS_ERR
  • IC_PKGS_MST
  • IC_PLNT_INV
  • IC_PRCE_CLS
  • IC_PRCH_CLS
  • IC_PURG_PRM
  • IC_RANK_MST
  • IC_SALE_CLS
  • IC_SHIP_CLS
  • IC_STAT_RPT
  • IC_STOR_CLS
  • IC_SUMM_INV
  • IC_TAXN_ASC
  • IC_TAXN_CLS
  • IC_TEXT_HDR
  • IC_TEXT_TBL_TL
  • IC_TRAN_ARC
  • IC_TRAN_CMP
  • IC_TRAN_PND
  • IC_TXN_REQUEST_HEADERS
  • IC_TXN_REQUEST_LINES
  • IC_WHSE_INV
  • IC_WHSE_MST
  • IC_WHSE_REL
  • IC_WHSE_STS
  • IC_XFER_MST
  • IN_ADDR_MST
  • IN_CTRY_MST
  • IN_ITEM_MST
  • IN_REGN_MST
  • IN_STAT_CTL
  • IN_STAT_DTL
  • IN_STAT_HDR
  • IN_STAT_MSG
  • IN_TEXT_HDR
  • IN_TEXT_TBL_TL
  • IN_TOFD_MST
  • SY_WF_ITEM_ROLES

Views in Process Manufacturing Regulatory Management Module

List of Views in Oracle Process Manufacturing Regulatory Management Module

GR_ALL_ITEMS_V
GR_COUNTRY_PROFILES_V
GR_DISPATCH_HISTORIES_DFV
GR_DISPATCH_HISTORY_V
GR_DOC_HDR_FTR_V
GR_DOCUMENT_CODES_DFV
GR_DOCUMENT_CODES_TL_V
GR_DOCUMENT_CODES_V
GR_DOCUMENT_PRINT_DFV
GR_DOCUMENT_STRUCTURES_DFV
GR_EIN_ASL_CONCS_V
GR_EIN_HAZARDS_V
GR_EIN_NUMBERS_B_V
GR_EIN_NUMBERS_TL_V
GR_EIN_RISKS_V
GR_EIN_SAFETY_V
GR_EMEA_DFV
GR_EURO_CLASSN_RISKS_V
GR_EUROHAZARDS_B_V
GR_EUROHAZARDS_TL_V
GR_EUROHAZARDS_VL
GR_EXPOSURE_AUTHS_B_V
GR_EXPOSURE_AUTHS_TL_V
GR_EXPOSURE_AUTHS_VL
GR_EXPOSURE_TYPES_B_V
GR_EXPOSURE_TYPES_TL_V
GR_EXPOSURE_TYPES_VL
GR_GENERIC_ITEMS_B_DFV
GR_GENERIC_ITEMS_VL
GR_GENERIC_ML_NAME_TL_DFV
GR_GENERIC_ML_NAME_TL_V
GR_HAZARD_GROUPS_V
GR_INV_FORMULA_V1
GR_INV_RECIPE_V1
GR_ITEM_CLASSNS_VL
GR_ITEM_CODES_V
GR_ITEM_EXPOSURE_DFV
GR_ITEM_EXPOSURE_VL
GR_ITEM_FIELD_NAME_MASKS_VL
GR_ITEM_GENERAL_DFV
GR_ITEM_GENERAL_MSDS_V
GR_ITEM_GENERAL_V
GR_ITEM_GROUPS_B_V
GR_ITEM_GROUPS_TL_V
GR_ITEM_GROUPS_VL
GR_ITEM_REPORT_V1
GR_ITEM_RISK_PHRASES_VL
GR_ITEM_SAFETY_PHRASES_VL
GR_ITEM_TOXIC_DFV
GR_ITEM_TOXIC_VL
GR_ITEMS_INGRED_XML
GR_ITEMS_XML
GR_LABEL_CLASS_RESPS_V
GR_LABEL_CLASSES_B_DFV
GR_LABEL_CLASSES_B_V
GR_LABEL_CLASSES_TL_V
GR_LABEL_CLASSES_VL
GR_LABEL_PROD_CLASSES_V
GR_LABEL_PROP_V
GR_LABEL_PROPERTIES_V
GR_LABELS_B_DFV
GR_LABELS_TL_V
GR_LABELS_VL
GR_MAIN_HEADINGS_B_V
GR_MAIN_HEADINGS_TL_V
GR_MULTILINGUAL_NAME_TL_DFV
GR_MULTILINGUAL_NAME_TL_V
GR_ORDER_INFO_V
GR_OTHER_NAMES_ORGN_V
GR_OTHER_NAMES_TL_V
GR_OTHER_PROPERTY_XML
GR_PHRASE_CONCS_DFV
GR_PHRASE_CONCS_V
GR_PHRASE_CONFLICTS_V
GR_PHRASE_GROUPS_V
GR_PHRASE_TYPES_V
GR_PHRASES_B_DFV
GR_PHRASES_B_V
GR_PHRASES_TL_DFV
GR_PHRASES_TL_V
GR_PHRASES_VL
GR_PHYSICAL_PROPERTY_XML
GR_PROPERTIES_TL_V
GR_PROPERTY_VAL_V
GR_RECIPIENT_INFO_DFV
GR_RECIPIENT_INFO_V
GR_REG_ITEM_CODE_V
GR_REGION_LANG_V
GR_RELATED_ITEMS_XML
GR_RISK_COMBINATIONS_V
GR_RISK_PHRASES_B_DFV
GR_RISK_PHRASES_B_V
GR_RISK_PHRASES_TL_V
GR_RISK_PHRASES_VL
GR_SAFETY_COMBINATIONS_V
GR_SAFETY_PHRASES_B_DFV
GR_SAFETY_PHRASES_B_V
GR_SAFETY_PHRASES_TL_V
GR_SAFETY_PHRASES_VL
GR_SALES_ORDER_FLEX_V
GR_SUB_HEADINGS_B_V
GR_SUB_HEADINGS_TL_V
GR_TOXIC_EFFECTS_B_V
GR_TOXIC_EFFECTS_TL_V
GR_TOXIC_EFFECTS_VL
GR_TOXIC_ROUTES_B_V
GR_TOXIC_ROUTES_TL_V
GR_TOXIC_ROUTES_VL
GR_TOXIC_SPECIES_B_V
GR_TOXIC_SPECIES_TL_V
GR_TOXIC_SPECIES_VL