VIEW: APPS.EGO_GTN_MUL_ATTR_CHG_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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