[Home] [Help] [Dependency Information]
Object Name: | EGO_GTIN_HAZMAT_ATTRS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_GTIN_HAZMAT_ATTRS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B | |
GLOBAL_TRADE_ITEM_NUMBER | VARCHAR2 | (255) | Yes | Global Trade Item Number |
CLASS_OF_DANGEROUS_CODE | VARCHAR2 | (4) | Class of Dangerous Goods Code | |
DANGEROUS_GOODS_MARGIN_NUMBER | VARCHAR2 | (30) | Dangerous Goods Margin Number | |
DANGEROUS_GOODS_HAZARDOUS_CODE | VARCHAR2 | (10) | Dangerous Goods Hazardous Code | |
DANGEROUS_GOODS_PACK_GROUP | VARCHAR2 | (3) | Dangerous Goods Package Group | |
DANGEROUS_GOODS_REG_CODE | VARCHAR2 | (3) | Dangerous Goods Regulation Code | |
DANGEROUS_GOODS_SHIPPING_NAME | VARCHAR2 | (80) | Dangerous Goods Shipping Name | |
UNITED_NATIONS_DANG_GOODS_NO | NUMBER | (4) | United Nations Dangerous Goods Number | |
FLASH_POINT_TEMP | NUMBER | (3) | Flash Point Temperature | |
UOM_FLASH_POINT_TEMP | VARCHAR2 | (3) | Unit of Measure for Flash Point Temperature | |
DANGEROUS_GOODS_TECHNICAL_NAME | VARCHAR2 | (200) | Dangerous Goods Technical Name |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, GLOBAL_TRADE_ITEM_NUMBER
, CLASS_OF_DANGEROUS_CODE
, DANGEROUS_GOODS_MARGIN_NUMBER
, DANGEROUS_GOODS_HAZARDOUS_CODE
, DANGEROUS_GOODS_PACK_GROUP
, DANGEROUS_GOODS_REG_CODE
, DANGEROUS_GOODS_SHIPPING_NAME
, UNITED_NATIONS_DANG_GOODS_NO
, FLASH_POINT_TEMP
, UOM_FLASH_POINT_TEMP
, DANGEROUS_GOODS_TECHNICAL_NAME
FROM APPS.EGO_GTIN_HAZMAT_ATTRS_V;
APPS.EGO_GTIN_HAZMAT_ATTRS_V is not referenced by any database object
|
|
|