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_INV_ITEM_PROPERTIES

Object Details

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

Table of Regulatory Item properties details, includes the items details for Regulatory Items with regard to the Convergence model

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_INV_ITEM_PROPERTIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID INVENTORY_ITEM_ID LABEL_CODE PROPERTY_ID
GR_INV_ITEM_PROPERTIES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID INVENTORY_ITEM_ID LABEL_CODE SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER	(15)	Yes	Surrogate id uniquely identifying the organization.
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	Surrogate id uniquely identifying the Inventory Item.
SEQUENCE_NUMBER	NUMBER	(8)	Yes	Sequence Number for the respective Inventory Item ID.
PROPERTY_ID	VARCHAR2	(6)	Yes	Property ID for the respective Inventory Item ID.
LABEL_CODE	VARCHAR2	(5)	Yes	Label Code for the respective Inventory Item ID
NUMBER_VALUE	NUMBER	(15)		Number Value for the respective Inventory Item ID
ALPHA_VALUE	VARCHAR2	(240)		Alpha Value for the respective Inventory Item ID
DATE_VALUE	DATE			Date Value for the respective Inventory Item ID
CREATED_BY	NUMBER	(15)	Yes	Created By for the respective Inventory Item ID
CREATION_DATE	DATE		Yes	Creation Date for the respective Inventory Item ID
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last Updated By for the respective Inventory Item ID
LAST_UPDATE_DATE	DATE		Yes	Last Update Date for the respective Inventory Item ID
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login for the respective Inventory Item ID

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SEQUENCE_NUMBER
,      PROPERTY_ID
,      LABEL_CODE
,      NUMBER_VALUE
,      ALPHA_VALUE
,      DATE_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GR.GR_INV_ITEM_PROPERTIES;

Dependencies

[top of page]

GR.GR_INV_ITEM_PROPERTIES does not reference any database object

GR.GR_INV_ITEM_PROPERTIES is referenced by following:

APPS: GR_INV_ITEM_PROPERTIES; GR_INV_ITEM_PROPERTIES_TG