VIEW: APPS.EGO_ITEM_GTIN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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