Product: | EGO - Advanced Product Catalog |
---|---|
Description: | View for multi row gtin attributes |
Implementation/DBA Data: | APPS.EGO_ITM_GTN_MUL_ATTRS_VL |
SELECT B.EXTENSION_ID
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.ITEM_CATALOG_GROUP_ID
, B.REVISION_ID
, B.ATTR_GROUP_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.MANUFACTURER_GLN
, B.MANUFACTURER_ID
, B.PARTY_RECEIVING_PRIVATE_DATA
, B.BAR_CODE_TYPE
, B.COLOR_CODE_LIST_AGENCY
, B.COLOR_CODE_VALUE
, B.CLASS_OF_DANGEROUS_CODE
, B.DANGEROUS_GOODS_MARGIN_NUMBER
, B.DANGEROUS_GOODS_HAZARDOUS_CODE
, B.DANGEROUS_GOODS_PACK_GROUP
, B.DANGEROUS_GOODS_REG_CODE
, B.DANGEROUS_GOODS_SHIPPING_NAME
, B.UNITED_NATIONS_DANG_GOODS_NO
, B.FLASH_POINT_TEMP
, B.UOM_FLASH_POINT_TEMP
, B.COUNTRY_OF_ORIGIN
, B.HARMONIZED_TARIFF_SYS_ID_CODE
, B.SIZE_CODE_LIST_AGENCY
, B.SIZE_CODE_VALUE
, TL.HANDLING_INSTRUCTIONS_CODE
, TL.DANGEROUS_GOODS_TECHNICAL_NAME
, B.DELIVERY_METHOD_INDICATOR
FROM EGO_ITM_GTN_MUL_ATTRS_B B
, EGO_ITM_GTN_MUL_ATTRS_TL TL
WHERE B.EXTENSION_ID = TL.EXTENSION_ID
AND TL.LANGUAGE = USERENV('LANG')