View: EGO_GTN_MUL_ATTR_CHG_VL

Product:	EGO - Advanced Product Catalog
Description:	This view stores the pending changes information for GDSN multi row attributes
Implementation/DBA Data:	APPS.EGO_GTN_MUL_ATTR_CHG_VL

View Text

SELECT B.EXTENSION_ID EXTENSION_ID
, B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, B.ORGANIZATION_ID ORGANIZATION_ID
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, B.REVISION_ID REVISION_ID
, B.ATTR_GROUP_ID ATTR_GROUP_ID
, B.MANUFACTURER_GLN MANUFACTURER_GLN
, B.MANUFACTURER_ID MANUFACTURER_ID
, B.PARTY_RECEIVING_PRIVATE_DATA PARTY_RECEIVING_PRIVATE_DATA
, B.BAR_CODE_TYPE BAR_CODE_TYPE
, B.COLOR_CODE_LIST_AGENCY COLOR_CODE_LIST_AGENCY
, B.COLOR_CODE_VALUE COLOR_CODE_VALUE
, B.CLASS_OF_DANGEROUS_CODE CLASS_OF_DANGEROUS_CODE
, B.DANGEROUS_GOODS_MARGIN_NUMBER DANGEROUS_GOODS_MARGIN_NUMBER
, B.DANGEROUS_GOODS_HAZARDOUS_CODE DANGEROUS_GOODS_HAZARDOUS_CODE
, B.DANGEROUS_GOODS_PACK_GROUP DANGEROUS_GOODS_PACK_GROUP
, B.DANGEROUS_GOODS_REG_CODE DANGEROUS_GOODS_REG_CODE
, B.DANGEROUS_GOODS_SHIPPING_NAME DANGEROUS_GOODS_SHIPPING_NAME
, B.UNITED_NATIONS_DANG_GOODS_NO UNITED_NATIONS_DANG_GOODS_NO
, B.FLASH_POINT_TEMP FLASH_POINT_TEMP
, B.UOM_FLASH_POINT_TEMP UOM_FLASH_POINT_TEMP
, B.COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, B.HARMONIZED_TARIFF_SYS_ID_CODE HARMONIZED_TARIFF_SYS_ID_CODE
, B.SIZE_CODE_LIST_AGENCY SIZE_CODE_LIST_AGENCY
, B.SIZE_CODE_VALUE SIZE_CODE_VALUE
, B.MASTER_ORG_EXTENSION_ID MASTER_ORG_EXTENSION_ID
, TL.HANDLING_INSTRUCTIONS_CODE HANDLING_INSTRUCTIONS_CODE
, TL.DANGEROUS_GOODS_TECHNICAL_NAME DANGEROUS_GOODS_TECHNICAL_NAME
, B.DELIVERY_METHOD_INDICATOR DELIVERY_METHOD_INDICATOR
, B.CHANGE_ID CHANGE_ID
, B.CHANGE_LINE_ID CHANGE_LINE_ID
, B.ACD_TYPE ACD_TYPE
, B.IMPLEMENTATION_DATE IMPLEMENTATION_DATE
FROM EGO_GTN_MUL_ATTR_CHG_B B
, EGO_GTN_MUL_ATTR_CHG_TL TL
WHERE B.EXTENSION_ID = TL.EXTENSION_ID
AND B.CHANGE_LINE_ID = TL.CHANGE_LINE_ID
AND B.ACD_TYPE = TL.ACD_TYPE
AND TL.LANGUAGE = USERENV('LANG')

Columns