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

TABLE: GR.GR_INGREDIENT_CONC_DETAILS

Object Details
Object Name: GR_INGREDIENT_CONC_DETAILS
Object Type: TABLE
Owner: GR
FND Design Data: TableGR.GR_INGREDIENT_CONC_DETAILS
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GR_INGREDIENT_CONC_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnSOURCE_ITEM_ID
ColumnINGREDIENT_ITEM_ID
ColumnLEVEL_HIERARCHY_CODE
GR_INGREDIENT_CONC_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnINGREDIENT_ITEM_ID
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.
INGREDIENT_ITEM_ID NUMBER (15) Yes Ingredient Item ID identifying the ingredient details
SOURCE_ITEM_ID NUMBER (15) Yes Source Item ID identifying the Inventory Item details
LEVEL_HIERARCHY_CODE NUMBER (10) Yes Level Hierarchy Code
WORK_CONCENTRATION NUMBER
Yes Work Concentration
UOM VARCHAR2 (3) Yes UOM
QUANTITY NUMBER
Yes Quantity
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      INGREDIENT_ITEM_ID
,      SOURCE_ITEM_ID
,      LEVEL_HIERARCHY_CODE
,      WORK_CONCENTRATION
,      UOM
,      QUANTITY
FROM GR.GR_INGREDIENT_CONC_DETAILS;

Dependencies

[top of page]

GR.GR_INGREDIENT_CONC_DETAILS does not reference any database object

GR.GR_INGREDIENT_CONC_DETAILS is referenced by following:

SchemaGR
ViewGR_INGREDIENT_CONC_DETAILS#