DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1562: FROM mtl_system_items_kfv

1558: x_return_status := l_return_status;
1559: WHEN material_status_err THEN
1560: SELECT substr(concatenated_segments,1,100)
1561: INTO l_item
1562: FROM mtl_system_items_kfv
1563: WHERE organization_id = l_mmti_rec.organization_id
1564: AND inventory_item_id = l_mmti_rec.inventory_item_id;
1565: OPEN get_location(l_mmti_rec.organization_id, l_mmti_rec.subinventory_code, l_mmti_rec.locator_id);
1566: FETCH get_location INTO l_locator;

Line 1754: FROM mtl_system_items_kfv

1750: EXCEPTION
1751: WHEN material_status_err THEN
1752: SELECT substr(concatenated_segments,1,100)
1753: INTO l_item
1754: FROM mtl_system_items_kfv
1755: WHERE organization_id = gme_common_pvt.g_organization_id
1756: AND inventory_item_id = l_inventory_item_id;
1757: SELECT transaction_type_name
1758: INTO l_type