You are browsing the archive for GR.

Process Manufacturing Regulatory Management Forms

Oracle Process Manufacturing Regulatory Management Forms:

FORM SHORT CODE ORACLE FORM NAME
GRFRM001 Territory Profiles
GRFRM002 Ingredient Concentration Ranges
GRFRM003 Region Codes
GRFRM004 Product Class Codes
GRFRM005 Label Class Codes
GRFRM006 Disclosure Codes
GRFRM007 Label Codes
GRFRM008 Phrase Library
GRFRM009 Phrase Groups
GRFRM010 Conflict Actions
GRFRM011 Risk Phrases
GRFRM012 Safety Phrases
GRFRM013 Toxic Effects
GRFRM014 Toxic Routes of Administration
GRFRM015 Toxic Species
GRFRM016 Exposure Authorities
GRFRM017 Exposure Types
GRFRM018 Document Structures
GRFRM019 Recipient Information
GRFRM020 Master Item Associations
GRFRM021 Cover Letters
GRFRM022 Organization Contacts
GRFRM023 Regulatory Item Information
GRFRM037 Print Recipient Documents
GRFRM039 Hazard Classification Codes
GRFRM040 Hazard Classification Groups
GRFRM043 Main Headings
GRFRM044 Sub Headings
GRFRM046 Phrase Type Codes
GRFRM047 Select Print Options
GRFRM048 Approve Print Selections
GRFRM049 Update Completed Batches
GRFRM050 Properties
GRFRM052 Item Group Codes
GRFRM053 Recipient Address Types
GRFRM057 Print Documents
GRFRM058 Print Worksheets
GRFRM059 Update Rebuild Indicator
GRFRM060 Stylesheets
GRFRM041 European Index Numbers
GRFRM923 Regulatory Item Information Details
GRFRM904 Product Class Code
GRFRM906 Disclosure Code Details
GRFRM905 Field Name Class Codes
GRFRM907 Field Names
GRFRM911 Risk Phrase Details
GRFRM912 Safety Phrase Details
GRFRM941 European Index Number Details
GRFRM952 Item Group Code Details
GRDDHIST Document Dispatch History
GRFRM901 Territory Profiles(1)
GRFRM035 Field Name Class Assignments

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