[Home] [Help] [Dependency Information]
Object Name: | EGO_GTN_MUL_ATTR_CHG_B# |
---|---|
Object Type: | VIEW |
Owner: | EGO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | (15) | Yes | |
INVENTORY_ITEM_ID | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ITEM_CATALOG_GROUP_ID | NUMBER | (15) | ||
REVISION_ID | NUMBER | (15) | ||
ATTR_GROUP_ID | NUMBER | (15) | Yes | |
MANUFACTURER_GLN | VARCHAR2 | (35) | ||
MANUFACTURER_ID | NUMBER | (15) | ||
PARTY_RECEIVING_PRIVATE_DATA | VARCHAR2 | (35) | ||
BAR_CODE_TYPE | VARCHAR2 | (35) | ||
COLOR_CODE_LIST_AGENCY | VARCHAR2 | (3) | ||
COLOR_CODE_VALUE | VARCHAR2 | (20) | ||
CLASS_OF_DANGEROUS_CODE | VARCHAR2 | (4) | ||
DANGEROUS_GOODS_MARGIN_NUMBER | VARCHAR2 | (30) | ||
DANGEROUS_GOODS_HAZARDOUS_CODE | VARCHAR2 | (10) | ||
DANGEROUS_GOODS_PACK_GROUP | VARCHAR2 | (3) | ||
DANGEROUS_GOODS_REG_CODE | VARCHAR2 | (3) | ||
DANGEROUS_GOODS_SHIPPING_NAME | VARCHAR2 | (80) | ||
UNITED_NATIONS_DANG_GOODS_NO | NUMBER | (4) | ||
FLASH_POINT_TEMP | NUMBER | (3) | ||
UOM_FLASH_POINT_TEMP | VARCHAR2 | (3) | ||
COUNTRY_OF_ORIGIN | VARCHAR2 | (2) | ||
HARMONIZED_TARIFF_SYS_ID_CODE | NUMBER | (10) | ||
SIZE_CODE_LIST_AGENCY | VARCHAR2 | (3) | ||
SIZE_CODE_VALUE | VARCHAR2 | (20) | ||
MASTER_ORG_EXTENSION_ID | NUMBER | (15) | ||
DELIVERY_METHOD_INDICATOR | VARCHAR2 | (20) | ||
CHANGE_ID | NUMBER | Yes | ||
CHANGE_LINE_ID | NUMBER | Yes | ||
ACD_TYPE | VARCHAR2 | (30) | Yes | |
IMPLEMENTATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT EXTENSION_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ITEM_CATALOG_GROUP_ID
, REVISION_ID
, ATTR_GROUP_ID
, 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
, MASTER_ORG_EXTENSION_ID
, DELIVERY_METHOD_INDICATOR
, CHANGE_ID
, CHANGE_LINE_ID
, ACD_TYPE
, IMPLEMENTATION_DATE
FROM EGO.EGO_GTN_MUL_ATTR_CHG_B#;
|
|
|