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


VIEW: APPS.GR_ITEM_GENERAL_V

Object Details
Object Name: GR_ITEM_GENERAL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGR.GR_ITEM_GENERAL_V
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
ORGANIZATION_ID NUMBER
Yes Surrogate id uniquely identifying the organization.
INVENTORY_ITEM_ID NUMBER
Yes Surrogate id uniquely identifying the Inventory Item.
ITEM_CODE VARCHAR2 (40)
Item Code for the respective Inventory Item ID
ITEM_GROUP_CODE VARCHAR2 (0)
Item Group Code for the respective Inventory Item ID
PRIMARY_CAS_NUMBER VARCHAR2 (30)
Primary CAS Number for the respective Inventory Item ID
INGREDIENT_FLAG VARCHAR2 (1)
Ingredient Flag for the respective Inventory Item ID
EXPLODE_INGREDIENT_FLAG VARCHAR2 (1)
Explode Ingredient Flag for the respective Inventory Item ID
FORMULA_SOURCE_INDICATOR CHAR (1)
Formula Source Indicator for the respective Inventory Item ID
USER_ID NUMBER
Yes User Id for the respective Inventory Item ID
INTERNAL_REFERENCE_NUMBER VARCHAR2 (0)
Internal Reference Number for the respective Inventory Item ID
PRODUCT_LABEL_CODE VARCHAR2 (0)
Product Label Code for the respective Inventory Item ID
VERSION_CODE VARCHAR2 (0)
Version Code for the respective Inventory Item ID
LAST_VERSION_CODE VARCHAR2 (0)
Last Version Code for the respective Inventory Item ID
PRODUCT_CLASS VARCHAR2 (0)
Product Class for the respective Inventory Item ID
ACTUAL_HAZARD NUMBER (7)
PRINT_INGREDIENT_PHRASES_FLAG VARCHAR2 (0)
Product Class for the respective Inventory Item ID
ATTRIBUTE_CATEGORY VARCHAR2 (0)
ATTRIBUTE1 VARCHAR2 (0)
ATTRIBUTE2 VARCHAR2 (0)
ATTRIBUTE3 VARCHAR2 (0)
ATTRIBUTE4 VARCHAR2 (0)
ATTRIBUTE5 VARCHAR2 (0)
ATTRIBUTE6 VARCHAR2 (0)
ATTRIBUTE7 VARCHAR2 (0)
ATTRIBUTE8 VARCHAR2 (0)
ATTRIBUTE9 VARCHAR2 (0)
ATTRIBUTE10 VARCHAR2 (0)
ATTRIBUTE11 VARCHAR2 (0)
ATTRIBUTE12 VARCHAR2 (0)
ATTRIBUTE13 VARCHAR2 (0)
ATTRIBUTE14 VARCHAR2 (0)
ATTRIBUTE15 VARCHAR2 (0)
ATTRIBUTE16 VARCHAR2 (0)
ATTRIBUTE17 VARCHAR2 (0)
ATTRIBUTE18 VARCHAR2 (0)
ATTRIBUTE19 VARCHAR2 (0)
ATTRIBUTE20 VARCHAR2 (0)
ATTRIBUTE21 VARCHAR2 (0)
ATTRIBUTE22 VARCHAR2 (0)
ATTRIBUTE23 VARCHAR2 (0)
ATTRIBUTE24 VARCHAR2 (0)
ATTRIBUTE25 VARCHAR2 (0)
ATTRIBUTE26 VARCHAR2 (0)
ATTRIBUTE27 VARCHAR2 (0)
ATTRIBUTE28 VARCHAR2 (0)
ATTRIBUTE29 VARCHAR2 (0)
ATTRIBUTE30 VARCHAR2 (0)
CREATED_BY NUMBER
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
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

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
,      ITEM_CODE
,      ITEM_GROUP_CODE
,      PRIMARY_CAS_NUMBER
,      INGREDIENT_FLAG
,      EXPLODE_INGREDIENT_FLAG
,      FORMULA_SOURCE_INDICATOR
,      USER_ID
,      INTERNAL_REFERENCE_NUMBER
,      PRODUCT_LABEL_CODE
,      VERSION_CODE
,      LAST_VERSION_CODE
,      PRODUCT_CLASS
,      ACTUAL_HAZARD
,      PRINT_INGREDIENT_PHRASES_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.GR_ITEM_GENERAL_V;

Dependencies

[top of page]

APPS.GR_ITEM_GENERAL_V references the following:

SchemaAPPS
SynonymGR_ITEM_EXPLOSION_PROPERTIES
SynonymMTL_SYSTEM_ITEMS_KFV
APPS.GR_ITEM_GENERAL_V is referenced by following:

SchemaAPPS
Package BodyGR_ITEM_SAFETY - show dependent code
ViewGR_REG_ITEM_CODE_V
Package BodyGR_WF_UTIL_PVT - show dependent code