GR Views (92)

GR - Process Manufacturing Regulatory Management — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
GR_ALL_ITEMS_V	View of ITEM CODE + DESCRIPTION
GR_COUNTRY_PROFILES_V	Contains the rows for the country profiles
GR_DISPATCH_HISTORY_V
GR_DOCUMENT_CODES_TL_V	Contains the Document Code Description in Multiple Languages
GR_DOCUMENT_CODES_V	Contains the rows for the document code
GR_DOC_HDR_FTR_V	Document header view
GR_EIN_ASL_CONCS_V	a view of the approved supply list concentrations
GR_EIN_HAZARDS_V	Contains a row for each european index number hazard classification
GR_EIN_NUMBERS_B_V	Contains a row for each european index number
GR_EIN_NUMBERS_TL_V	Contains a row for each european index number language description
GR_EIN_RISKS_V	Contains a row for each european index number risk phrase code
GR_EIN_SAFETY_V	Contains a row for each european index number safety phrase code
GR_EUROHAZARDS_B_V	Contains the rows for the hazard classification code
GR_EUROHAZARDS_TL_V	Contains the rows for the hazard classification code that have a language dependent description for the hazard classification code
GR_EUROHAZARDS_VL	Contains the rows that have a language dependent description for the hazard code where the language is equal to the user environment variabl
GR_EURO_CLASSN_RISKS_V	Contains the risks assigned to the classifications
GR_EXPOSURE_AUTHS_B_V	Contains the rows for the exposure authority code
GR_EXPOSURE_AUTHS_TL_V	Contains the rows that have a language dependent description for the exposure authority code
GR_EXPOSURE_AUTHS_VL	Contains the rows that have a language dependent description for the exposure authority code where the language is equal to the user environ
GR_EXPOSURE_TYPES_B_V	Contains the rows for the exposure type code
GR_EXPOSURE_TYPES_TL_V	Contains the rows that have a language dependent description for the exposure type code.
GR_EXPOSURE_TYPES_VL	Contains the rows that have a language dependent description for the exposure type code.
GR_GENERIC_ITEMS_VL	Contains the rows that have a language dependent description for the generic item code where the language is equal to the user environment
GR_GENERIC_ML_NAME_TL_V	Contains the rows that have a language dependent name description for the generic item code where the language is equal to the user environ
GR_HAZARD_GROUPS_V	Contains the rows for the hazard group code
GR_INV_FORMULA_V1	View for Getting a distinct Formula No
GR_INV_RECIPE_V1	View for Getting a distinct Recipe No
GR_ITEMS_INGRED_XML	View for Master Item Associations + Inventory Item and its associated Inventory Items details
GR_ITEMS_XML	View for Inventory Item to generate the xml data
GR_ITEM_CLASSNS_VL	Contains the rows for the item classification code that have a language dependent description for the item classification code
GR_ITEM_CODES_V	Contains the Item Code Description in GR_ITEM_GENERAL & IC_ITEM_MST
GR_ITEM_EXPOSURE_VL	Contains the rows for the item exposure code that have a language dependent description for theitem exposure code
GR_ITEM_FIELD_NAME_MASKS_VL	Translated View of Regulatory Item Field Name Masks
GR_ITEM_GENERAL_MSDS_V	Contains only the rows that reflect the MSDS name for the item in the users environment language
GR_ITEM_GENERAL_V	View of Regulatory Item details, includes the items details for Regulatory Items with regard to the Convergence model
GR_ITEM_GROUPS_B_V	Contains the rows for the item group code
GR_ITEM_GROUPS_TL_V	Contains the rows that have a language dependent item group description.
GR_ITEM_GROUPS_VL	Contains the rows that have a language dependent description for the item group code where the language is equal to the user environment var
GR_ITEM_REPORT_V1	View of valid Regulatory Items which can be used for Reports.
GR_ITEM_RISK_PHRASES_VL	Contains the rows that have a language dependent description for the item risk phrase where the language is equal to the user environment va
GR_ITEM_SAFETY_PHRASES_VL	Contains the rows that have a language dependent description for the item safety phrase where the language is equal to the user environment
GR_ITEM_TOXIC_VL	Contains the rows that have a language dependent description for the item toxic phrase where the language is equal to the user environment
GR_LABELS_TL_V	Contains the rows that have a language dependent description for the label code where the language is equal to the user environment variab
GR_LABELS_VL	Contains the rows that have a language dependent description for the label code where the language is equal to the user environment variabl
GR_LABEL_CLASSES_B_V	Contains the rows that have a language dependent description for the label class code.
GR_LABEL_CLASSES_TL_V	Contains the rows that have a language dependent description for the label class code.
GR_LABEL_CLASSES_VL	Contains the rows that have a language dependent description for the label class code where the language is equal to the user environment v
GR_LABEL_CLASS_RESPS_V	Contains the rows for the label class responsibility code.
GR_LABEL_PROD_CLASSES_V	Label production classes view
GR_LABEL_PROPERTIES_V	Label properties view
GR_LABEL_PROP_V	Contains the rows for the label property code.
GR_MAIN_HEADINGS_B_V	Contains the rows for the main heading code
GR_MAIN_HEADINGS_TL_V	Contains the rows that have a language dependent description for the main headings code
GR_MULTILINGUAL_NAME_TL_V	Contains all the rows for the table
GR_ORDER_INFO_V	View of Order Fulfillment tables and Order Management tables
GR_OTHER_NAMES_ORGN_V	This view selects unique item/organization combinations from the GR_OTHER_NAMES_TL table and denormalizes the foreign key to the SY_ORGN_MST
GR_OTHER_NAMES_TL_V	Contains rows that have a language dependent description for the item/organization combinations for the GR_OTHER_NAMES_TL table.
GR_OTHER_PROPERTY_XML	View for Inventory Item and its associated Other Physical Properties details
GR_PHRASES_B_V	Contains the rows that have a language dependent description for the phrase code.
GR_PHRASES_TL_V	Contains the rows that have a language dependent description for the phrase code.
GR_PHRASES_VL	Contains the rows that have a language dependent description for the phrase code where the language is equal to the user environment variab
GR_PHRASE_CONCS_V	Contains the rows for the phrase concentrations
GR_PHRASE_CONFLICTS_V	Contains the rows for the phrase conflicts
GR_PHRASE_GROUPS_V	Contains the rows for the phrase group code
GR_PHRASE_TYPES_V	Contains the rows for the phrase type code
GR_PHYSICAL_PROPERTY_XML	View for Inventory Item and its associated Physical Properties details
GR_PROPERTIES_TL_V	Contains the rows that have a language dependent description for the property code
GR_PROPERTY_VAL_V	Contains the rows for the property values table
GR_RECIPIENT_INFO_V	Contains the rows for the recipients information table
GR_REGION_LANG_V	Contains the rows for the region languages table
GR_REG_ITEM_CODE_V	View for Regulatory Items with Description
GR_RELATED_ITEMS_XML	View for Master Item Associations + Inventory Item and its associated Inventory Items details
GR_RISK_COMBINATIONS_V	Contains the rows for the risk combination code
GR_RISK_PHRASES_B_V	Contains the rows for the risk phrase code
GR_RISK_PHRASES_TL_V	Contains the rows that have a language dependent description for the risk phrases code
GR_RISK_PHRASES_VL	Contains the rows that have a language dependent description for the risk phrase code where the language is equal to the user environment v
GR_SAFETY_COMBINATIONS_V	Contains the rows for the safety combination code
GR_SAFETY_PHRASES_B_V	Contains the rows for the safety phrase code
GR_SAFETY_PHRASES_TL_V	Contains the rows that have a language dependent description for the safety phrase code
GR_SAFETY_PHRASES_VL	Contains the rows that have a language dependent description for the risk phrase code where the language is equal to the user environment va
GR_SALES_ORDER_FLEX_V	View of SALES ORDER NUMBER+ LINE NUMBER + ORDER COMMENTS + NAME + ITEM NUMBER
GR_SUB_HEADINGS_B_V	Contains the rows for the sub heading code
GR_SUB_HEADINGS_TL_V	Contains the rows that have a language dependent
GR_TOXIC_EFFECTS_B_V	Contains the rows that have a language dependent description for the toxic effect code
GR_TOXIC_EFFECTS_TL_V	Contains the rows that have a language dependent description for the toxic effect code
GR_TOXIC_EFFECTS_VL	Contains the rows that have a language dependent description for the toxic effect code where the language is equal to the user environment v
GR_TOXIC_ROUTES_B_V	Contains the rows that have a language dependent description for the toxic route code
GR_TOXIC_ROUTES_TL_V	Contains the rows that have a language dependent description for the toxic route code
GR_TOXIC_ROUTES_VL	Contains the rows that have a language dependent description for the toxic route code where the language is equal to the user environment va
GR_TOXIC_SPECIES_B_V	Contains the rows that have a language dependent description for the toxic species code
GR_TOXIC_SPECIES_TL_V	Contains the rows that have a language dependent description for the toxic species code
GR_TOXIC_SPECIES_VL	Contains the rows that have a language dependent description for the toxic species code where the language is equal to the user environment