You are browsing the archive for Oracle Process Manufacturing Regulatory Management.

Oracle Process Manufacturing Regulatory Management Tables

Oracle Process Manufacturing Regulatory Management module – List of database tables:

  • GR_ADDITIVE_CALCS
  • GR_ADD_MANDATORY_RISKS
  • GR_AUDIT
  • GR_CALCULATED
  • GR_CALCULATION_NAMES
  • GR_CONC_RANGES
  • GR_COUNTRY_PROFILES
  • GR_COVER_LETTERS_B
  • GR_COVER_LETTERS_TL
  • GR_DISCLOSURES
  • GR_DISPATCH_HISTORIES
  • GR_DISPATCH_HISTORY
  • GR_DOCUMENT_CODES
  • GR_DOCUMENT_CODES_TL
  • GR_DOCUMENT_DETAILS
  • GR_DOCUMENT_HEADINGS
  • GR_DOCUMENT_PRINT
  • GR_DOCUMENT_RTK
  • GR_DOCUMENT_STRUCTURES
  • GR_DOC_HDR_FTR
  • GR_EIN_ASL_CONCS
  • GR_EIN_ASL_RISKS
  • GR_EIN_HAZARDS
  • GR_EIN_NUMBERS_B
  • GR_EIN_NUMBERS_TL
  • GR_EIN_RISKS
  • GR_EIN_SAFETY
  • GR_EMEA
  • GR_EUROHAZARDS_B
  • GR_EUROHAZARDS_TL
  • GR_EURO_CLASSN_RISKS
  • GR_EURO_DEFAULT_CONCS
  • GR_EURO_MANDATORY_RISKS
  • GR_EXPOSURE_AUTHS
  • GR_EXPOSURE_AUTHS_B
  • GR_EXPOSURE_AUTHS_TL
  • GR_EXPOSURE_AUTH_T
  • GR_EXPOSURE_TYPES_B
  • GR_EXPOSURE_TYPES_TL
  • GR_GENERIC_ITEMS_B
  • GR_GENERIC_ML_NAME_TL
  • GR_HAZARD_GROUPS
  • GR_INGREDIENT_CONCENTRATIONS
  • GR_INGREDIENT_CONC_DETAILS
  • GR_INV_ITEM_PROPERTIES
  • GR_ITEMS_REQUESTED
  • GR_ITEM_CLASSNS
  • GR_ITEM_CONCENTRATIONS
  • GR_ITEM_CONC_DETAILS
  • GR_ITEM_DISCLOSURES
  • GR_ITEM_DOCUMENT_DTLS
  • GR_ITEM_DOC_STATUSES
  • GR_ITEM_EXPLOSION_PROPERTIES
  • GR_ITEM_EXPOSURE
  • GR_ITEM_FIELD_NAME_MASKS_B
  • GR_ITEM_FIELD_NAME_MASKS_TL
  • GR_ITEM_GENERAL
  • GR_ITEM_GENERAL_MIG
  • GR_ITEM_GROUPS_B
  • GR_ITEM_GROUPS_TL
  • GR_ITEM_PROPERTIES
  • GR_ITEM_RIGHT_TO_KNOW
  • GR_ITEM_RISK_PHRASES
  • GR_ITEM_SAFETY_PHRASES
  • GR_ITEM_TOXIC
  • GR_LABELS_B
  • GR_LABELS_TL
  • GR_LABEL_CLASSES_B
  • GR_LABEL_CLASSES_TL
  • GR_LABEL_CLASS_RESPS
  • GR_LABEL_PROD_CLASSES
  • GR_LABEL_PROPERTIES
  • GR_LINKED_RISKS
  • GR_MAIN_HEADINGS_B
  • GR_MAIN_HEADINGS_TL
  • GR_MULTILINGUAL_NAME_TL
  • GR_ORGANIZATION_CONTACTS
  • GR_OTHER_NAMES_TL
  • GR_PHRASES_B
  • GR_PHRASES_TL
  • GR_PHRASE_CONCS
  • GR_PHRASE_CONFLICTS
  • GR_PHRASE_GROUP_ASSOC
  • GR_PHRASE_GROUP_CODES
  • GR_PHRASE_TYPES
  • GR_PRODUCT_CLASSES
  • GR_PROPERTIES_B
  • GR_PROPERTIES_TL
  • GR_PROPERTY_VALUES_TL
  • GR_PROP_CHNG_TEMP
  • GR_RECIPIENT_ADDRESSES
  • GR_RECIPIENT_ADDR_TYPES
  • GR_RECIPIENT_DOCUMENTS
  • GR_RECIPIENT_INFO
  • GR_REGIONS
  • GR_REGION_LANGUAGES
  • GR_RISK_CALCULATIONS
  • GR_RISK_COMBINATIONS
  • GR_RISK_PHRASES_B
  • GR_RISK_PHRASES_TL
  • GR_SAFETY_CATEGORIES_B
  • GR_SAFETY_CATEGORIES_TL
  • GR_SAFETY_COMBINATIONS
  • GR_SAFETY_PHRASES_B
  • GR_SAFETY_PHRASES_TL
  • GR_SAFETY_RULES
  • GR_SELECTION
  • GR_SELECTION_HEADER
  • GR_SOURCE_RISKS
  • GR_SPHRASE_CONFLICTS
  • GR_SUB_HEADINGS_B
  • GR_SUB_HEADINGS_TL
  • GR_TOXIC_EFFECTS_B
  • GR_TOXIC_EFFECTS_TL
  • GR_TOXIC_ROUTES_B
  • GR_TOXIC_ROUTES_TL
  • GR_TOXIC_SPECIES_B
  • GR_TOXIC_SPECIES_TL
  • GR_UPLOAD_FILE_TMP
  • GR_WORK_ADDITIVES
  • GR_WORK_ADDITIVE_RISKS
  • GR_WORK_AUDIT
  • GR_WORK_BUILD_DOCS
  • GR_WORK_CLASSNS
  • GR_WORK_CLASSN_RISKS
  • GR_WORK_COUNTRY
  • GR_WORK_HEAVY_ELEMENTS
  • GR_WORK_INGRED_CONCS
  • GR_WORK_SAFETY_CATEGORY
  • GR_WORK_SAFETY_PHRASES
  • GR_WORK_WORKSHEETS
  • GR_XML_PROPERTIES_MAP

Process Manufacturing Regulatory Management Profile Options

Oracle Process Manufacturing Regulatory Management Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
GR_3RD_PARTY_SITE_ID GR: Partner Application Site ID
GR_WHSE_DEFAULT GR: Default Warehouse Code
GR_SO_CHECK_FOR_HAZARDS GR: Sales Order check for Hazardous Flag
GR_SOAPACTION GR: Soapaction
GR_WS_SERVICE_NAMESPACE GR: Ws Service Namespace
GR_DOC_MANAGEMENT GR: Document Management
GR_DOC_MGMT_FILE_EXISTS_ACT GR: File Exists Action
GR_PROP65_CARCINOGENIC GR: PROP65 Carcinogenic Phrase
GR_PROP65_TERATOGENIC GR: PROP65 Teratogenic Phrase
GR_DEFAULT_TEMPERATURE GR: Default Temperature Calculation
GR_PROP65_BOTH GR: PROP65 Carcinogenic & Teratogenic Phrase
GR_TOXIC_INFO GR: Toxic Calculation Field Name
GR_TOXIC_UOM GR: LC50 Toxic Calculation UOM
GR_DEFAULT_TOXIC_CALC_VALUE GR: Default Toxic Calculation Value
GR_CALC_OSHA_FLAMM GR: Calculate OSHA Flammability
GR_DEFAULT_DISCLOSURE GR: Default Disclosure
GR_DEFAULT_SAFETY_CATEGORY GR: Default Safety Category
GR_MAINTAIN_ITEM_DOCUMENTS GR: Maintain Item Documents
GR_OPM_VERSION GR: OPM Version
GR_ORGN_DEFAULT GR: Default Organization Code
GR_OTHER_NAME_PRINT GR: Other Name Print
GR_SYNONYM_ORDER GR: Other Name Order
GR_TERRITORY_DEFAULT GR: Default Territory
GR_USE_WORKFLOW GR: Use Workflow
GR_DOC_UPD_REQ_WF_ENABLED GR: Document Rebuild Required Workflow Enable

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