View: EGO_ITEM_GTIN_V

Product:	EGO - Advanced Product Catalog
Description:	View for item gtin details
Implementation/DBA Data:	APPS.EGO_ITEM_GTIN_V

View Text

SELECT MXR.INVENTORY_ITEM_ID
, MP.ORGANIZATION_ID
, MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER
, MP.MASTER_ORGANIZATION_ID
, MXR.CROSS_REFERENCE GTIN
, MXR.DESCRIPTION
, MXR.ORG_INDEPENDENT_FLAG
, MXR.UOM_CODE
, MUOM.UNIT_OF_MEASURE
, MSIK.TRADE_ITEM_DESCRIPTOR
, EGA.PUBLICATION_STATUS
FROM MTL_CROSS_REFERENCES MXR
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_UNITS_OF_MEASURE MUOM
, MTL_PARAMETERS MP
, EGO_ITEM_GTN_ATTRS_VL EGA
WHERE MSIK.INVENTORY_ITEM_ID = EGA.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = EGA.ORGANIZATION_ID
AND MSIK.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MXR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND NVL(MXR.ORGANIZATION_ID
, MSIK.ORGANIZATION_ID) = MSIK.ORGANIZATION_ID
AND MXR.UOM_CODE = MSIK.PRIMARY_UOM_CODE
AND MXR.CROSS_REFERENCE_TYPE = 'GTIN'
AND MUOM.UOM_CODE = MSIK.PRIMARY_UOM_CODE

Columns