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

VIEW: APPS.EGO_ITM_GTN_MUL_ATTRS_VL

Object Details
Object Name: EGO_ITM_GTN_MUL_ATTRS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEGO.EGO_ITM_GTN_MUL_ATTRS_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXTENSION_ID NUMBER (15) Yes Unique identifier for the attribute row
INVENTORY_ITEM_ID NUMBER (15) Yes Foreign key to MTL_SYSTEM_ITEMS_B
ORGANIZATION_ID NUMBER (15) Yes Foreign key to MTL_SYSTEM_ITEMS_B
ITEM_CATALOG_GROUP_ID NUMBER (15)
Foreign key to MTL_ITEM_CATALOG_GROUPS_B - used for search
REVISION_ID NUMBER (15)
Foreign key to item revisions
ATTR_GROUP_ID NUMBER (15)
User attribute group id
CREATED_BY NUMBER (15) Yes User id of Person who created record
CREATION_DATE DATE
Yes Date record was created
LAST_UPDATED_BY NUMBER (15) Yes User id of last person modifying the record
LAST_UPDATE_DATE DATE
Yes Date record was last modified
LAST_UPDATE_LOGIN NUMBER (15)
Login of last person who updated record
MANUFACTURER_GLN VARCHAR2 (35)
Global Location Number of Manufacturer
MANUFACTURER_ID NUMBER (15)
Foreign key to MTL_MANUFACTURERS
PARTY_RECEIVING_PRIVATE_DATA VARCHAR2 (35)
Name of Party receiving private data
BAR_CODE_TYPE VARCHAR2 (35)
Bar Code Type
COLOR_CODE_LIST_AGENCY VARCHAR2 (3)
Color Code List Agency
COLOR_CODE_VALUE VARCHAR2 (20)
Color Code Value
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
COUNTRY_OF_ORIGIN VARCHAR2 (2)
Country of Origin for item
HARMONIZED_TARIFF_SYS_ID_CODE NUMBER (10)
Harmonized Tariff System Identification Code
SIZE_CODE_LIST_AGENCY VARCHAR2 (3)
Size Code List Agency
SIZE_CODE_VALUE VARCHAR2 (20)
Size Code Value
HANDLING_INSTRUCTIONS_CODE VARCHAR2 (5)
Handling Instructions Code
DANGEROUS_GOODS_TECHNICAL_NAME VARCHAR2 (200)
Dangerous Goods Technical Name
DELIVERY_METHOD_INDICATOR VARCHAR2 (20)
Delivery Method Indicator
Query Text

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


SELECT EXTENSION_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ITEM_CATALOG_GROUP_ID
,      REVISION_ID
,      ATTR_GROUP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MANUFACTURER_GLN
,      MANUFACTURER_ID
,      PARTY_RECEIVING_PRIVATE_DATA
,      BAR_CODE_TYPE
,      COLOR_CODE_LIST_AGENCY
,      COLOR_CODE_VALUE
,      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
,      COUNTRY_OF_ORIGIN
,      HARMONIZED_TARIFF_SYS_ID_CODE
,      SIZE_CODE_LIST_AGENCY
,      SIZE_CODE_VALUE
,      HANDLING_INSTRUCTIONS_CODE
,      DANGEROUS_GOODS_TECHNICAL_NAME
,      DELIVERY_METHOD_INDICATOR
FROM APPS.EGO_ITM_GTN_MUL_ATTRS_VL;

Dependencies

[top of page]

APPS.EGO_ITM_GTN_MUL_ATTRS_VL references the following:

SchemaAPPS
SynonymEGO_ITM_GTN_MUL_ATTRS_B
SynonymEGO_ITM_GTN_MUL_ATTRS_TL
APPS.EGO_ITM_GTN_MUL_ATTRS_VL is referenced by following:

SchemaAPPS
Package BodyEGO_GTIN_ATTRS_PVT - show dependent code
ViewEGO_GTIN_HAZMAT_ATTRS_V
PL/SQL PackageEGO_ITEM_PUB - show dependent code
Package BodyENG_CHANGE_IMPORT_UTIL - show dependent code