VIEW: APPS.EGO_GTIN_ATTRS_TL_V

Source

View Text - Preformatted

SELECT MSI.INVENTORY_ITEM_ID, MSI.ORGANIZATION_ID, MXR.CROSS_REFERENCE AS GLOBAL_TRADE_ITEM_NUMBER, DECODE(MST.LANGUAGE, 'US', 'EN', MST.LANGUAGE) LANGUAGE, MST.SOURCE_LANG, EGT.DESCRIPTIVE_SIZE, EGT.FUNCTIONAL_NAME, EGT.INVOICE_NAME, EGT.WARRANTY_DESCRIPTION, EGT.TRADE_ITEM_FINISH_DESCRIPTION, EGT.DESCRIPTION_SHORT, MST.DESCRIPTION AS ADDITIONAL_TRADE_ITEM_DESC FROM MTL_SYSTEM_ITEMS_B MSI, MTL_SYSTEM_ITEMS_TL MST, MTL_CROSS_REFERENCES MXR, EGO_ITEM_GTN_ATTRS_TL EGT, MTL_PARAMETERS MP WHERE MSI.INVENTORY_ITEM_ID = EGT.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = EGT.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MST.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MST.ORGANIZATION_ID AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID AND MXR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND NVL(MXR.ORGANIZATION_ID, MSI.ORGANIZATION_ID) = MSI.ORGANIZATION_ID AND MXR.UOM_CODE = MSI.PRIMARY_UOM_CODE AND MXR.CROSS_REFERENCE_TYPE = 'GTIN' AND MST.LANGUAGE = EGT.LANGUAGE

View Text - HTML Formatted

SELECT MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, MXR.CROSS_REFERENCE AS GLOBAL_TRADE_ITEM_NUMBER
, DECODE(MST.LANGUAGE
, 'US'
, 'EN'
, MST.LANGUAGE) LANGUAGE
, MST.SOURCE_LANG
, EGT.DESCRIPTIVE_SIZE
, EGT.FUNCTIONAL_NAME
, EGT.INVOICE_NAME
, EGT.WARRANTY_DESCRIPTION
, EGT.TRADE_ITEM_FINISH_DESCRIPTION
, EGT.DESCRIPTION_SHORT
, MST.DESCRIPTION AS ADDITIONAL_TRADE_ITEM_DESC
FROM MTL_SYSTEM_ITEMS_B MSI
, MTL_SYSTEM_ITEMS_TL MST
, MTL_CROSS_REFERENCES MXR
, EGO_ITEM_GTN_ATTRS_TL EGT
, MTL_PARAMETERS MP
WHERE MSI.INVENTORY_ITEM_ID = EGT.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = EGT.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MST.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MST.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MXR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND NVL(MXR.ORGANIZATION_ID
, MSI.ORGANIZATION_ID) = MSI.ORGANIZATION_ID
AND MXR.UOM_CODE = MSI.PRIMARY_UOM_CODE
AND MXR.CROSS_REFERENCE_TYPE = 'GTIN'
AND MST.LANGUAGE = EGT.LANGUAGE