VIEW: APPS.EGO_ITM_GTN_MUL_ATTRS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')