eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GR.GR_ITEM_RIGHT_TO_KNOW

Object Details

Object Name:	GR_ITEM_RIGHT_TO_KNOW
Object Type:	TABLE
Owner:	GR
FND Design Data:	GR.GR_ITEM_RIGHT_TO_KNOW
Subobject Name:
Status:	VALID

Contains product composition information pertinent to each state's reporting level.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_ITEM_RIGHT_TO_KNOW_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_CODE LOCATION_SEGMENT_QUALIFIER LOCATION_SEGMENT_VALUE PARENT_SEGMENT_ID
GR_ITEM_RIGHT_TO_KNOW_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_SEGMENT_QUALIFIER LOCATION_SEGMENT_VALUE PARENT_SEGMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_CODE	VARCHAR2	(32)	Yes	The Item Code for the substance used in or produced by the process.
LOCATION_SEGMENT_QUALIFIER	VARCHAR2	(30)	Yes	Identifies which authority this location is for. Values may be sourced from RA_ADDRESSES.
LOCATION_SEGMENT_VALUE	VARCHAR2	(60)	Yes	Upper case of the value in AR_LOCATION_VALUES.LOCATION_SEGMENT_USER_VALUE
PARENT_SEGMENT_ID	NUMBER		Yes	Identifies which location 'owns' this location (for example, which State owns this County)
MIN_INGREDIENTS_TO_PRINT	NUMBER	(15)	Yes	The minimum number of ingredients to print on the Right-To-Know label.
RTK_REPORTING_LEVEL	VARCHAR2	(15)		The percentage above which the ingredient must be printed on the Right-to-Know label. A Right-to-Know label discloses the contents of materials by labeling containers with the appropriate ingredients.
USE_MSDS_NAME_FLAG	VARCHAR2	(1)	Yes	Y or N to indicate whether to use the MSDS Name for the Right-To-Know label.
RTK_NAME	VARCHAR2	(240)	Yes	The name that should be printed on the RTK label if the MSDS name is not used.
PRINT_CAS_NUMBER_FLAG	VARCHAR2	(1)		Y or N to indicate whether to print the primary CAS Number on the document.
TRADE_SECRET_FLAG	VARCHAR2	(1)		Y or N to indicate whether there is a Trade Secret for the item.
TRADE_SECRET_NAME	VARCHAR2	(32)		The name of the confidential formula, pattern, process, device, or information.
TRADE_SECRET_EXP_DATE	DATE			The date that the Trade Secret expires. Examples of valid date formats are: MM/DD/YY, DD/MM/YY, DD-MON-YYYY.
TRADE_SECRET_PERMIT	VARCHAR2	(32)		The Trade Secret Permit Number.
STATE_DEFINED_ITEM_TYPE	VARCHAR2	(1)	Yes	The State Defined Item Type to override the default. For example, in certain states, especially California, some items defined as products, are defined as ingredients for the state SARA reporting.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ITEM_CODE
,      LOCATION_SEGMENT_QUALIFIER
,      LOCATION_SEGMENT_VALUE
,      PARENT_SEGMENT_ID
,      MIN_INGREDIENTS_TO_PRINT
,      RTK_REPORTING_LEVEL
,      USE_MSDS_NAME_FLAG
,      RTK_NAME
,      PRINT_CAS_NUMBER_FLAG
,      TRADE_SECRET_FLAG
,      TRADE_SECRET_NAME
,      TRADE_SECRET_EXP_DATE
,      TRADE_SECRET_PERMIT
,      STATE_DEFINED_ITEM_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GR.GR_ITEM_RIGHT_TO_KNOW;

Dependencies

[top of page]

GR.GR_ITEM_RIGHT_TO_KNOW does not reference any database object

GR.GR_ITEM_RIGHT_TO_KNOW is referenced by following:

GR: GR_ITEM_RIGHT_TO_KNOW#