Skip to content

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

VIEW: APPS.GR_ITEMS_INGRED_XML

Object Details
Object Name: GR_ITEMS_INGRED_XML
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGR.GR_ITEMS_INGRED_XML
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGNID NUMBER (15) Yes Identifying the Organization Id.
ITEMID NUMBER (15) Yes Identifying the Inventory Item Id.
ITEMCODE VARCHAR2 (40)
Identifying the Inventory Item Code.
INGREDIENTCODE VARCHAR2 (40)
Identifying the Ingredients associated with the Inventory Item.
INGREDIENTNAME VARCHAR2 (240)
Identifying the Ingredient Name that is associated with the Inventory Item.
CLASSIFICATION VARCHAR2 (30)
Identifying the Classification that is associated with the Inventory Item.
CLASSIFICATIONTYPE CHAR (7)
Identifying the Classification Type that is associated with the Inventory Item.
PERCENT1 NUMBER
Yes Identifying the Ingredient Percentages that is associated with the Inventory Item.
PERCENT1QUALIFIER CHAR (1)
Identifying the Ingredient Percentages Qualifier that is associated with the Inventory Item.
PERCENTWEIGHTVOLUMEIDENTIFIER CHAR (1)
Identifying the Ingredient Percentages Weight Volume Identifier that is associated with the Inventory Item.
Query Text

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


SELECT ORGNID
,      ITEMID
,      ITEMCODE
,      INGREDIENTCODE
,      INGREDIENTNAME
,      CLASSIFICATION
,      CLASSIFICATIONTYPE
,      PERCENT1
,      PERCENT1QUALIFIER
,      PERCENTWEIGHTVOLUMEIDENTIFIER
FROM APPS.GR_ITEMS_INGRED_XML;

Dependencies

[top of page]

APPS.GR_ITEMS_INGRED_XML references the following:

SchemaAPPS
SynonymGR_INGREDIENT_CONCENTRATIONS
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.GR_ITEMS_INGRED_XML is not referenced by any database object