DBA Data[Home] [Help]

APPS.EGO_GTIN_ATTRS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 2706: FROM MTL_SYSTEM_ITEMS_KFV MSIK, EGO_ITEM_GTN_ATTRS_B EGA

2702: Debug_Msg('12. EanuccCode and EanuccType must be unique');
2703: IF l_eanucc_valid AND l_eanucc_code IS NOT NULL AND l_eanucc_type IS NOT NULL THEN
2704: BEGIN
2705: SELECT MSIK.INVENTORY_ITEM_ID, CONCATENATED_SEGMENTS INTO l_item_id, l_item_number
2706: FROM MTL_SYSTEM_ITEMS_KFV MSIK, EGO_ITEM_GTN_ATTRS_B EGA
2707: WHERE EGA.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
2708: AND EGA.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
2709: AND EGA.EANUCC_CODE = l_eanucc_code
2710: AND EGA.EANUCC_TYPE = l_eanucc_type